Select A2:A367

FormatCFFormula is: =A2=TODAY()

Choose a color and OK your way out.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 10:30:08 -0400, "John" wrote:

I have a list of dates starting from A2 to A367 and I would like to
Highlight the current date.
I can do it by placing the function "DATE() " in a cell and reference that
cell but I can't do it
in Conditional Formatting using "Formula is " with a Function.
Is it possible or I need to have a date in a cell to refer to.
Regards
John