View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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