Is this possible

[Sean15]

Hi:

What is the proper formular for: =If (A12 is colored red, “Outstanding”,”Settled”). Thanks for your help.

Sean

 

[BAlGaInTl]

Hi:

What is the proper formular for: =If (A12 is colored red, “Outstanding”,”Settled”). Thanks for your help.

Sean

You can't really construct a formula based on a cell format.

What makes the cell red now? Is there some condition that causes that to happen?

 

[Sean15]

Yes you are right. I just figured out what I have to do to make this work. Thanks.

 

[Sean15]

Hi:

I have the conditions in L25:L758. The condition are "Outstanding" or "Settled".

I want to color the cells in column H25:H758 red for "Outstanding" and no color for "Settled") if the above conditions are met in L25:L758.

I intended to use conditional formatting but I can't seem to make it work. Could someone advise.


Sean