Conditional Format Trama ...
 

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

Conditional Format Trama ...
 

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

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