Recent content by Tonyjstone

Hi Lee, I don't know how many colour formats you need, but this is a procedure I developed some months ago and it works in the circumstances I have on one application. It may do for you. If you use Excel Conditional Formats & Excel Custom Formats you can have up to 6 Conditional Formats for...

Thanks lupins46 for your effort. This problem is on a database at a colleagues office. I also, could not replicate the problem and I reckon it is in the original formatting of the "Date " col when they created the database. They say it is formatted as 'datetime' but..... I have connected them...

The version is MS Office Pro 2003 The export was via "tools", then "analyse with MS Excel" The field was set as a datetime field. Thanks

If you can assist I would be grateful: We have a database in access which is 5 cols wide and 800 rows deep. One col shows date, and is formatted in access as 'long date'. When we copy the database to an Excel sheet, (to facilitate manipulation as skills in Access are primitive), the date col...

Hi Ken, Thanks Ken. That worked! Artificial Intelligence is no match for Natural Stupidity..

I have recently invested in a new PC which has XP Home and was given Excel 2003 with the package. I am trying to install my "Personal.xls" from the old PC onto the new machine. but find I cannot access the XLStart folder to store the Personal file. I appreciate that the remedy may lie within XP...

Hi Glenn, That may be my only viable choice. Thanks for the response. Remember, half the people you know are below average.

Hi All, I have a spreadsheet which is a general file of expenses with one of the columns being 'Description'. In order to analyse the cumulative values I use an array formula which sums the values by description. {=SUM(($C$1:$C$80)*($D$1:$D$80=D88))} One of the descriptions is uniformly...

Hi GUJU, If you were to colour the entire 1000 row field pale grey, and then, with the selection highlighted, select Conditional Format, Formula is, then enter this =MOD(ROW(),5) click Format and select the colour White, then click OK the selection will have every 5th row tinted grey.

Hi Comboy, I'm not sure if this is what you want, but nesting the statements seems to deliver the result you request. =IF(A1=15,"Reprint 5",IF(A1=10,"Reprint 10","Full Stock")) Naturally you will have to make the cell references relevant, and the visible statements can be adjusted.

Thank you all for your help. I seem to have been led astray by the very useful XLFunction guide by Peter Noneley which I use to expand my meagre knowledge of functions. That workbook demonstrates the =month function in the manner I expected, not, as it is and has been described by your good...

An unusual feature has started to appear on my Excel. Whenever I use the =MONTH function in a cell formatted for 'mmm' or 'mmmm' or anything other than 'number', the only result I can get is Jan or January, regardless of the date entered. The function does not produce the correct month...

Hello Ken, No I didn't , and I should have. I will take the trouble to do so in future. The content is is usually the solution required. Thanks for the comment. Tony

Many thanx Tony, I was sure there was a sequence like that. Oh how I wish I had paid attention last time Have a star

I am exporting a file from a "SAGE" Accounts application in an Excel format and then pasting it into a more complex excel sheet. On each occasion that the data is exported some of the rows of exported data contain blanks (not zeros, BLANKS, EMPTY CELLS), the range of empty cells is...