Today's Due Date in Colour

[Keith Camacho]

Please help.
I have a column called "Due Date" I will like every morning, to have all the
dates that are due the current day (()Today) to be highlited in red. Can
this be done, if so how?
Thanks.

/keith

 

[Ron de Bruin]

Hi Keith

You can use CF
http://www.contextures.com/xlCondFormat01.html

 

[Paul B]

Keith, if your column is A then select it and format, conditional formatting

Formula is =A1=TODAY() and set the Patten to red

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003