Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can this be done? Conditional formatting
E should reflect the following
if N=0 nothing if N=1 then pattern if P has any data Green if P has no data Red F should reflect the following if M=0 nothing if M=1 then pattern if Q has any data Green if Q has no data Red Thanks for the help! Angela |
#2
|
|||
|
|||
What does "nothing" mean? Is Green and Red your Pattern color? So if
N=0, P doesn't matter? In that case, one way: CF1: Formula is =AND(N=1,ISBLANK(P)) Format1: Patterns/Red CF2: Formula is =(N=1) Format2: Patterns/Green In article , "AngelaG" wrote: E should reflect the following if N=0 nothing if N=1 then pattern if P has any data Green if P has no data Red |
#3
|
|||
|
|||
Angela, Conditional Formatting only allows 3 conditions. You have four. N column =1 P column = blank N column =0 P column = something N column =0 P column = blank N column =1 P column = something Formatting is applied based on the first true condition met. Note Using multiple conditions If more than one specified condition is true, Microsoft Excel applies only the formats of the first true condition, even if more than one condition is true. In other words Excel doesn't "stack up" formatting from two conditional formatting formulas which might both be true. Maybe one of the Excel Gurus has a trick, but I don't believe you can do what you want. HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=397216 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |