software

gt; I am using Excel 2003.
gt; I want to use a conditional format to identify by a different color when a
gt; 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
Yes, just select the whole column and use a formula like

=AND(H1lt;=TODAY() 120,A1lt;gt;quot;quot;)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Elveyquot; gt; wrote in message
...
gt; gt; I am using Excel 2003.
gt; gt; I want to use a conditional format to identify by a different color when
a
gt; gt; date is 120 and 160 days on from a given date .
gt; The data has different dates so can I highlight each column or do I have
to
gt; do each one?
gt;
gt; Thanks
gt;
gt; Elvey
gt;
gt;
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 formatgt;conditional formatgt;cell
valuegt;equal togt;120 cell,gt; formatgt;addgt;cell valuegt;equal togt;160 cellgt; format
--
paul

remove nospam for email addy!
quot;Elveyquot; wrote:

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