Conditional Formatting with Today() Function.

[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

 

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

 

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

 

[Gord Dibben]

Select A2:A367

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

Choose a color and OK your way out.


Gord Dibben MS Excel MVP

 

[John]

Thank you Elisabeth
Its working fine.

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]

Thank you All for your reply
I got it working thanks to you all.
Regards
John