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