pls help me find the easiest way

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!!!

wow excellent thank you very much indeed, thanks for the quick response i really appreciate that...

in your suggestion you stated the solution to be:

=A1>TODAY()

however instead of writing "today" will excel and can excel change that date to the date the spreadsheet is opened...

so lets say i open it tomorrow for example then today would equal 12/1/2006 and all the things which have expired which be highlighted RED??

Is that at all possible?

Looking forward to hearing from you,

Thanks in advance...

Cheers!!

Hi,

Despite you guys being such great help and even telling me the formula I require to resolve my problem I am still experiencing difficulty so I am trying to attach a document which I cannot do to further explain why I am having trouble implementing your formula..

1. Five columns consisting of different dates
2. If I add the formula you provided it each cell in each column I recieve the formula error msg.

So where does the date ? Does it go inbetween the brackets? for example:

this is your suggested formula:

=A1>TODAY()


is this how it would work:

=A1>TODAY(10/06/2006)

Please please clarify???

Thanks in advance...

So close now...

I wish I could upload the file to show you what it is I mean...

Please help

Many thanks