| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format or conditional format? | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
