Please HELP me!!!!

A

ayette

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??
 
D

David Biddulph

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

Bob Phillips

Conditional formatting.

Select all the dates.

Goto menu Format>Conditional 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)
 
T

Toppers

Use Conditional formatting:

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

HTH
 
D

Don Guillett

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