I have dates in a column example 1-March-07 to 10-March-07. what i
wanted to do is to automatically highlight the date today in a
different color. is that possible??

Format/ Conditional Formatting/ Cell value is: equal to =TODAY()
Select an appropriate format.
--
David Biddulph

"ayette" wrote in message
ups.com...
I have dates in a column example 1-March-07 to 10-March-07. what i
wanted to do is to automatically highlight the date today in a
different color. is that possible??

Conditional formatting.

Select all the dates.

Goto menu FormatConditional Formatting
Select equal to in the dropdown
Add =TODAY() in the editbox
Click Format
Select the Pattern tab
Choose a colout
OK
OK

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ayette" wrote in message
ups.com...
I have dates in a column example 1-March-07 to 10-March-07. what i
wanted to do is to automatically highlight the date today in a
different color. is that possible??

Use Conditional formatting:

Highlight your cells
Select Format=Conditional Formatting
FormulaIs: =A1=Today() ... change A1 to your first cell
Select colour (Pattern)
OK

HTH

"ayette" wrote:

I have dates in a column example 1-March-07 to 10-March-07. what i
wanted to do is to automatically highlight the date today in a
different color. is that possible??

You make it sound like a matter of life and death. Please!!!!!!!!!!!!!!! try
to use meaningful subject lines such as "highlight today's cell". Think of
the archives.

--
Don Guillett
SalesAid Software

"ayette" wrote in message
ups.com...
I have dates in a column example 1-March-07 to 10-March-07. what i
wanted to do is to automatically highlight the date today in a
different color. is that possible??