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

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

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

Select A2:A367

FormatCFFormula is: =A2=TODAY()

Choose a color and OK your way out.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 10:30:08 -0400, "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

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

Thank you All for your reply
I got it working thanks to you all.
Regards
John
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select A2:A367

FormatCFFormula is: =A2=TODAY()

Choose a color and OK your way out.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 10:30:08 -0400, "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