Conditional Formatting with Today() Function.
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.
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
--
Dave Peterson
|