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

Hi,

I have managed to attach the file...

So as you will see there are 5 - 6 columns.

I would like:

a) any dates which exceed the current date (TODAYS DATE) should be highlighted in red, everytime the spreadsheet is opened.

Please help

Thanks for all your help and advice in advance, your efforts are most appreciated

Many thanks

Cheers!!

hey,

thank you so much for your help I am sooo grateful..

Without being unappreciative and with no malice whatsoever having looked at the spreadsheet I noticed all dates which exceed the current date (TODAY) are highlighted in red...whereby the aim was to highlight any dates which had past the current date...perhaps I explained myself incorrectly, judging from your excel skills I believe the latter to be the case...

so for example:

you have highlighted all dates which exceed/are greater than 19/1/2007 when I would have liked all dates which have past 19/1/2007 to be highlighted..

Sorry to be a pain, I was hoping you could help me once again to resolve the matter??

Furthermore, when I click on the highlighted cells from your example, I do not see how the formula was inputted...usually there is a formula in the formula bar...is there any chance you could show this? so I could understand how to implement this formula in different scenarios?

Many thanks indeed, your help is mostly appreciated..thank you so very much

thanks in advance

Cheers!!!

thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank youthank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you

SO VERY MUCH....

I appreciate your help, perserverance and patience greatly...

Thank you once again....

hi

i copied your formula word for word in the hope it would show me all dates which are prior to todays date...it did not...

I know the forumla works and its my error for not getting it to work right again..

please can you do your magic as before, id be very grateful

thanks in advance..

cheers

p.s. i have attached a slightly diff worksheet, pls note i would all dates which are before todays date to be highlighted in red throughout the worksheet as i am to add 50 more numbers to column add...

thank you so very much