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?

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?

Say due date is in Column A, from A2 down.

Say you designate A1 to hold the number of days past due to trigger the
color change.

Say Column B is the column to format.

Select B2, then from the Menu Bar:
<Format <Conditional Format,
Change "Cell Value Is" to "Formula Is",
And enter this formula:

=AND($A$1+A2<=TODAY(),B2="",A2<"")

Then click on <Format, and choose a pattern to your liking,
then OK out.

You can then copy B2 down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Mark" wrote in message
...
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?