pls help me find the easiest way

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