Hi Mark,

Use Conditional format and set formula as follows:-

=AND(TODAY()-B2=7,A2="")

Assumes that:-
A2 is the cell with conditional format
B2 has the date to compare to today's date
7 is the number of days between today and date in B2

--
Regards,

OssieMac


"Mark" wrote:

How can I have a cell change color based on the fact that it is still empty
"X" number of days past another date in an adjacent cell?