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

"Duke Carey" wrote:

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

Go to FormatConditional Formatting and change the test from "Failed" to
"Non-conforms"

"ryanmhess" wrote:


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!