highlight a date
 

I am using Excel 2003.
I want to use a conditional format to identify by a different color when a
date is 120 and 160 days on from a given date .
The data has different dates so can I highlight each column or do I have to
do each one?

Thanks

Elvey

highlight a date
 

Yes, just select the whole column and use a formula like

=AND(H1<=TODAY()+120,A1<"")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Elvey" wrote in message
...
I am using Excel 2003.
I want to use a conditional format to identify by a different color when
a
date is 120 and 160 days on from a given date .
The data has different dates so can I highlight each column or do I have
to
do each one?

Thanks

Elvey

highlight a date
 

you can select a whole range and set your conditional format.Probably easier
to select a couple of cells somewhere and type =a1+120,in one and,a1+160 in
another then select your range then go to formatconditional formatcell
valueequal to120 cell, formataddcell valueequal to160 cell format
--
paul

remove nospam for email addy!



"Elvey" wrote:

I am using Excel 2003.
I want to use a conditional format to identify by a different color when a
date is 120 and 160 days on from a given date .
The data has different dates so can I highlight each column or do I have to
do each one?

Thanks

Elvey