Conditional Formatting with Today() Function.

J

John

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
 
E

Elisabeth D

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

Dave Peterson

Select A2:A367
Format|conditional formatting|
Cell Value is
Equal to:
=today()

and give it a nice format

====
ps.
=today() returns today's date.
=date(2008,8,31)
would return August 31, 2008.
 
G

Gord Dibben

Select A2:A367

Format>CF>Formula is: =A2=TODAY()

Choose a color and OK your way out.


Gord Dibben MS Excel MVP
 
J

John

Thank you Elisabeth
Its working fine.
Elisabeth D said:
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.
Click to expand...
 
Top