Conditional Format Trama ...
Oh YES ... Works GREAT ... Back on the road again ... Thanks ... Kha
"Toppers" wrote:
Try:
=(OR(AND(C2=1,H2F2*0.5),AND(C2=2,H2F2),AND(C2=3, H2F2*1.5)))
"Ken" wrote:
Excel2003 ... Can I write the following into 1 Condition Statement? I know I
can write it in 3, but I am looking to write it in 1 (cause I have plans for
the other 2) ... I would like PATTERN RED if any of the following conditions
are met:
C2=1 & H2(F2*.5)
C2=2 & H2F2
C2=3 & H2(F2*1.5)
Thanks ... Kha
|