Thread: If statements
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default If statements

click b12
select format--conditional formatting
Below "condition 1" select "Formula is"
in the box next to it type: =B10=0,85
click Format
click "Patterns"
select the colour you want
click ok
click "Add" (at the bottom)
Repeat the process for conditions 2 and 3 with these entries
=AND(B100,74;B10<0,84)
=B10<=0,74
click ok

Hans