Using Conditional Formatting to Pass/Fail
Assuming you got your values in column B, starting in B2:
The formula for the pass-rule
=AND(B2=2,B2<=8)
The formula for the fail-rule
=OR(B2<2,B28)
"mrsatroy" wrote:
I want to use conditional formatting to return a pass fail number based on a
numeric value. However the number has to fall between 2 values. i.e A product
will pass if the numeric value it achieves is between 2 and 8 but if the
value is less than 2 or greater than 8 it will fail. I can't seem to get the
if statement to understand the concept of pass being between 2 and 8.
--
mrsatroy
|