Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting conditional formatting rules | Excel Discussion (Misc queries) | |||
Why is conditional formatting disabled(!)? | Excel Discussion (Misc queries) | |||
WEEKDAY in Conditional Formatting? | Excel Worksheet Functions | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |