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
|