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

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

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