Thread: How to color a cell according to its content

The cell location is B2.

Cell content can be either "+" or "-".

I want to change the background color of B2 to green if its content is "+".
I want to change the background color of B2 to red if its content is "-".

How can I do this?

Thanks.

Search the Forum for Conditional Formatting

Thank you for quick reply.

I have already tried conditional formatting. It works when working with numbers, but has no effect when working with text.

Conditional formatting works with text, use "+" and "-"

Try
Cell Value is Equal to ="-"
Cell Value is Equal to ="+"

In the conditional format window

I tried writing ="+" and ="-" instad of simply writing + and -.
Doing this way, the demonstration in the cell didn't change, in other words, it didn't work.

Thanks in advance.

I attached the Excel file I'm working on.

You are not using conditional formatting in your example.

Here's is your workbook using conditional formatting.

Wooow, that's perfect, how did you do that?
Thanks alot!

Originally Posted by hkBattousai

I have already tried conditional formatting. It works when working with numbers, but has no effect when working with text.

Did you not already try conditional formatting?

Check this out.

http://www.contextures.com/xlCondFormat01.html

Thank you so much for your help!