Complicated (well to me it is!)

[That's Confidential]

In cell D7, I have the following forumla:-

=IF(ISNUMBER(C7),C7+14,"")

This cell is also conditional formates as follows:-

Formula is =D7<TODAY()

(it then changes to a red colour)

Now, in K7 I have a drop down menu with 2 choices, "Disposal" and
"Returned". What I would like is for if either of these two options are
selected from the list, then C7 is no longer shaded in red.

Does that make sense? Any ideas on how to do it? I am assuming that I would
have to add something to my conditional formula in D7?

Thanks in advance

 

[firefytr]

your assumption is correct.

=(D7<TODAY())*(K7="")

if those are the only two options ever to be in the cell (so if th
cell is blank). or...

=(D7<TODAY())*(OR(K7="Disposal",K7="Returned"))

do these help

 

[JE McGimpsey]

One way:

CF1: Formula Is =AND(D7<TODAY(),NOT(K7="Disposal"),NOT(K7="Returned"))

 

[JE McGimpsey]

firefytr: Did you test your second solution?

Your second CF doesn't meet the OP's specifications: "C7 is no longer
shaded in red" if K7 = Returned or K7 = Disposal

The CF below will cause C7 *to* be red if K7 = Returned or K7 =
Disposal, and if K7 is blank, C7 will always remain uncolored. You could
use:

=(D7<TODAY())*NOT(OR(K7="Disposal",K7="Returned"))

 

[That's Confidential]

JE,

You seem to have done the trick!

Thanks once again