If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Conditional Formatting to Pass/Fail
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 |
#2
|
|||
|
|||
Using Conditional Formatting to Pass/Fail
Conditonal formats return formats and not numbers. The CF should be farily
easy. if Cell value is not Between 2 and 8 then add your pattern. If you want a value returned then in a differnet cell use a formula something like =IF(AND(A1=2, A1=8), 1, 0) -- HTH... Jim Thomlinson "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 |
#3
|
|||
|
|||
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(B22,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 |
Thread Tools | |
Display Modes | |
|
|