highlight a date

E

Elvey

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 .
Click to expand...
The data has different dates so can I highlight each column or do I have to
do each one?

Thanks

Elvey
 
B

Bob Phillips

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)
 
P

paul

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 format>conditional format>cell
value>equal to>120 cell,> format>add>cell value>equal to>160 cell> format
 
Top