View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Catherine Catherine is offline
external usenet poster
 
Posts: 67
Default 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?