Can this be done? Conditional formatting

A

AngelaG

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
 
J

JE McGimpsey

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
 
C

Casey

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 conditio
is true, Microsoft Excel applies only the formats of the first tru
condition, even if more than one condition is true.

In other words Excel doesn't "stack up" formatting from two conditiona
formatting formulas which might both be true.

Maybe one of the Excel Gurus has a trick, but I don't believe you ca
do what you want.

HT
 
Top