Conditional Formatting based on a due date

M

Mark

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?
 
O

OssieMac

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
 
R

RagDyeR

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!
=====================================================


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?
 
Top