Flagging failed values.

R

ryanmhess

Awhile back I knew how to do this. I had the following formula show "PASSED"
in bold black text with a white background when it passed obviously and when
it failed I had it set up to shot "FAILED" in bold white text with a red
background.

=IF(AND(4.5<=B12,B12<=5.25),"PASSED","FAILED")

I was asked to change the formula as follows;

=IF(AND(4.5<=B12,B12<=5.25),"CONFORMS","NON-CONFORMS")

All I did was change the reply to whether or not the value in B12 passes or
fails and now when the value of B12 it pops up "NON-CONFORMS" in bold black
text in a white background when I want it to be bold white text in a red
background.

How do set this up to change the text and cell color when I get a failing
value?

Thank you in advance!
 
D

Duke Carey

Sounds as though you had conditional formatting set up, triggered when the
cells' values equaled 'FAILED'.

Go to Format>Conditional Formatting and change the test from "Failed" to
"Non-conforms"
 
R

ryanmhess

Ahh yes, that is what I was looking for and had forgotten. Thank you very
much!
 
G

Guest

Hi

You'll need to change your Format/Conditional Formatting settings to reflect
your changes.

Hope this helps.
Andy.
 
Top