one way in cell A1
Condition one formula is =if(b2<95,1,0) and format red
Condition 2 formula is =if(b2=95,if(B2<100,1,0),0) and format to yellow
If cell b2 is formated to % change to decimal .95 and 1.0
HTH

"Duser" wrote:

Can I conditionally format one cell that is affected by another cells
numbers? For example can i conditionally format a1 to be green if cell b2 is
<= to 100%, yellow if =95 but <100, and red if <95. And if so what is the
key stroke for <= in a function statement?