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
|