Flagging failed values.
 

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!

Flagging failed values.
 

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!

Flagging failed values.
 

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!

Flagging failed values.
 

Hi

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

Hope this helps.
Andy.

"ryanmhess" wrote in message
...

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!