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