Highlighting cell content based on content of another cell

  • Thread starter Thread starter bkarlstrom
  • Start date Start date
B

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?
 
bkarlstrom said:
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?
Click to expand...

Look at Conditional formatting on the Format menu.
 
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
 
Back
Top