conditional formatting

D

Duke Carey

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

Catherine

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.
 
D

Duke Carey

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
 
G

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.
 
C

Catherine

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

Duke Carey

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
 
D

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.
 
C

Catherine

Thanks, that worked.

Duke Carey said:
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
Click to expand...
 
Top