Highlighting cell content based on content of another cell

[bkarlstrom]

Hello,
I want to show the content of several cells in RED as
soon as I input a certain content in a specific cell. I
suppose I have to use an IF statement but I'm not sure
how to change the color of the text in that IF statement.
Can someone help?

 

[Paul]

Hello,
I want to show the content of several cells in RED as
soon as I input a certain content in a specific cell. I
suppose I have to use an IF statement but I'm not sure
how to change the color of the text in that IF statement.
Can someone help?

Look at Conditional formatting on the Format menu.

 

[Chip Pearson]

You can use Conditional Formatting from the Format menu to do
this. Select the cells you want to color, then open the CF
dialog. There, change "Cell Value Is" to "Formula Is" and enter a
formula that returns either TRUE or FALSE. Then click the Format
button and choose a cell format. If the formula returns TRUE,
that format will be applied to the cells. If the formula returns
FALSE, no formatting is applied to the cells.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks a lot Chip! I appreciate the speedy reply!
Bjorn