Hi,

I have setup a spreadsheet which contains:

a) 5 columns of dates
b) some names etc

ideally i would like to open the spreadsheet on a daily basis and for all the dates which exceed the days date to be highlighted in Red....for example:

today is 11/1/2007 so all the five columns which contain dates well the dates in these column which exceed 11/1/2007 would appear in Red....

How would I acheieve this?

Please help

Thanks in advance

Cheers!!!