conditional formatting

[Guest]

Can you conditionally format font color?

 

[Guest]

Absolutely. It's one of the options under the Format button in Conditional
Formatting

 

[Gary]

Yes you can. What is your condition?

 

[Guest]

I have the formula =IF(E9=F9,"Balanced","UNBALANCED") in a cell. If the
answer is "UNBALANCED," I want it to print out in red.

 

[Guest]

select the cell with the formula
from the menu choose Format->Conditional formatting
leave the first box set to "Cell value is"
select equal to in the second box
enter ="UNBALANCED" in the third box
click on the Format button

 

[Gary]

Select the cell, go to Format>Conditional Formatting>make sure there is CELL
VALUE IS in the first dropdown..... write "UNBALANCED" in the second box>>
click on format> there is a dropdown box right below the FONT STYLE box.
select a color and you're done.

 

[Guest]

I tried that already: cell value is, equal to, ="UNBALANCED", format, font
color, red
but it didn't work. Any suggestions?

 

[Guest]

You could try changing to Formula is and use

=E9<>F9

as your formula

Be sure you have selected the cell with the formula in it before going to
Conditional Formatting

 

[David Biddulph]

Are you sure that you haven't got a misprint in one of your formulae (for
example you've got a comma after UNBALANCED inside the quotes in your
question earlier)?

Use the cursor to select and copy your formulae (for the cell contents and
for the conditional formatting) and paste them here, rather than typing them
by hand and perhaps mistyping.

 

[Guest]

Thanks, that worked.

You could try changing to Formula is and use

=E9<>F9

as your formula

Be sure you have selected the cell with the formula in it before going to
Conditional Formatting