Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting with four conditions
Can it be done? I am trying to setup conditional formatting on the four
conditions. value in cell M4 less than value in cell P4 color yellow value in cell M4 greater than value in cell P4 color pink value in cell M4 equal value in cell P4 Or Cell P4 equal zero color purple PS this is my second day on using Excel |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting with four conditions
It's still only three different outcomes, so you can do this with conditional
formatting. The final condition would be =or(m4=p4,p4=0). Caveat: the order in which CFs are evaluated is such that the first condition satisfied gets applied. So the condition above should be set as the first condition; otherwise the p4=0 won't have a chance, as you'll already have satisfied one of the earlier conditions. --Bruce "Ring eye" wrote: Can it be done? I am trying to setup conditional formatting on the four conditions. value in cell M4 less than value in cell P4 color yellow value in cell M4 greater than value in cell P4 color pink value in cell M4 equal value in cell P4 Or Cell P4 equal zero color purple PS this is my second day on using Excel |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting with four conditions
Thanks again, I bought Step by Step book for Excel 2003 and I could not find
any sample in it. Did I buy the wrong book. "bpeltzer" wrote: It's still only three different outcomes, so you can do this with conditional formatting. The final condition would be =or(m4=p4,p4=0). Caveat: the order in which CFs are evaluated is such that the first condition satisfied gets applied. So the condition above should be set as the first condition; otherwise the p4=0 won't have a chance, as you'll already have satisfied one of the earlier conditions. --Bruce "Ring eye" wrote: Can it be done? I am trying to setup conditional formatting on the four conditions. value in cell M4 less than value in cell P4 color yellow value in cell M4 greater than value in cell P4 color pink value in cell M4 equal value in cell P4 Or Cell P4 equal zero color purple PS this is my second day on using Excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional formatting capability for 20+ conditions not just 3. | Excel Discussion (Misc queries) | |||
Additional Conditions for Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |