View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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