Search results for query: *

Thanks that worked great

Sorry not being clear....I have a column with dates, if the dates are older than 10 days and the adjacent column has an 'o' character in it then change the font of the date cell of that row to red.

Maybe something else you can help with please....I wanted to include an AND condition from the next column cell to color the text red. I cannot understand how to declare 2 ranges simultaneously.

Thanks Loomah it works great. My embedded skills is not really helping much with VBA so thanks a lot.

Any thoughts on a solution to color date according to the amount of days it is old?

If the cell has a datestamp of text in it that is older than 10 days then that datestamp text should color red with a timer routine that runs every few minutes. I know there are other methods ie. macros but I have other code that I would like to keep it together with.

How do I color code 2 date text conditions. The text will be a date and if it's older than say 10 days then red etc in Excel 2003? I could not get below to work: Range("D8:D100").FormatConditions.Add(xlCellValue, xlGreater, CLng(Date - 10)).Interior.ColorIndex = 3