conditional formatting
 

Can you conditionally format font color?

conditional formatting
 

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

"Catherine" wrote:

Can you conditionally format font color?

conditional formatting
 

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

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
on the Font tab choose red from the color dropdown
OK your way back to the spreadsheet


"Catherine" wrote:

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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

Select the cell, go to FormatConditional Formattingmake 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.

"Catherine" wrote in message
...
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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

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

"Gary" wrote:

Select the cell, go to FormatConditional Formattingmake 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.

"Catherine" wrote in message
...
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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

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


"Catherine" wrote:

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

"Gary" wrote:

Select the cell, go to FormatConditional Formattingmake 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.

"Catherine" wrote in message
...
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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

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.
--
David Biddulph

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

"Gary" wrote:

Select the cell, go to FormatConditional Formattingmake 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.

"Catherine" wrote in message
...
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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?

conditional formatting
 

Thanks, that worked.

"Duke Carey" wrote:

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


"Catherine" wrote:

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

"Gary" wrote:

Select the cell, go to FormatConditional Formattingmake 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.

"Catherine" wrote in message
...
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.

"Gary" wrote:

Yes you can. What is your condition?

"Catherine" wrote in message
...
Can you conditionally format font color?