Thank you Elisabeth
Its working fine.
"Elisabeth D" wrote in message
...
You are on the right track using Conditional Formatting.

Highight your column of dates

Condition: Cell value is equal to =TODAY()

Select the formatting you desire to apply.

"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