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!