Combine Conditional Formatting Rules formulae
 

I have 2 Conditional Formatting rules that result in ths same format
being applied to a cell, so would like to combine them to free up a
rule, however all my attempts have been unsuccessful.

Rule 1:
=AND(W60,W6<TODAY()-5,W6<TODAY(),D6<"Complete",D6<"Cancelled")
Rule 2: =OR(W6="Unknown",W6="Replanning")

Any suggestions gratefully received

Thanks and regards
Fred

Combine Conditional Formatting Rules formulae
 

One way:

=OR(W6="Unknown", W6="Replanning", AND(W60, W6<TODAY()-5,
W6<TODAY() ,D6<"Complete", D6<"Cancelled"))

In article . com,
"Fred" wrote:

I have 2 Conditional Formatting rules that result in ths same format
being applied to a cell, so would like to combine them to free up a
rule, however all my attempts have been unsuccessful.

Rule 1:
=AND(W60,W6<TODAY()-5,W6<TODAY(),D6<"Complete",D6<"Cancelled")
Rule 2: =OR(W6="Unknown",W6="Replanning")

Any suggestions gratefully received

Thanks and regards
Fred

Combine Conditional Formatting Rules formulae
 

Doh !

So obvious, because I had Rule 1, I simply attached the Or to it and
got nowhere.

Many thanks.

Combine Conditional Formatting Rules formulae
 

What about if I just want to combine something like
- If C6 = "1" or "16" or "8" or "9" Then the cell background would be a
specified color?

"JE McGimpsey" wrote:

One way:

=OR(W6="Unknown", W6="Replanning", AND(W60, W6<TODAY()-5,
W6<TODAY() ,D6<"Complete", D6<"Cancelled"))

In article . com,
"Fred" wrote:

I have 2 Conditional Formatting rules that result in ths same format
being applied to a cell, so would like to combine them to free up a
rule, however all my attempts have been unsuccessful.

Rule 1:
=AND(W60,W6<TODAY()-5,W6<TODAY(),D6<"Complete",D6<"Cancelled")
Rule 2: =OR(W6="Unknown",W6="Replanning")

Any suggestions gratefully received

Thanks and regards
Fred