F
Fred
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(W6>0,W6<TODAY()-5,W6<TODAY(),D6<>"Complete",D6<>"Cancelled")
Rule 2: =OR(W6="Unknown",W6="Replanning")
Any suggestions gratefully received
Thanks and regards
Fred
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(W6>0,W6<TODAY()-5,W6<TODAY(),D6<>"Complete",D6<>"Cancelled")
Rule 2: =OR(W6="Unknown",W6="Replanning")
Any suggestions gratefully received
Thanks and regards
Fred