Showing negative values for formula results in red

[sherden_hershey]

I have a formula in a cell that is formated as a percentage. I need the
formula results to be in red if the value is a negative number. How do I do
that?

 

[FSt1]

hi
custom format perhaps.....
0.00%;[Red]0.00%

regards
FSt1

 

[Tyro]

You can use conditional formatting Prior to Excel 2007, Format/Conditional
formatting, Excel 2007, Home Tab, Styles, Conditional Formattting, New Rule.
Use a formula. If you percentage is in A1, the formula is: =A1<0 then format
with a red font color.

Tyro

 

[T. Valko]

Assume the cell in question is cell A1

Select A1
Goto the menu Format>Conditional Formatting
Formula Is: =A1<0
Click the Format button
Select the Font tab
Select the desired color
OK out

 

[sherden_hershey]

This works. Thanks!!!

Assume the cell in question is cell A1

Select A1
Goto the menu Format>Conditional Formatting
Formula Is: =A1<0
Click the Format button
Select the Font tab
Select the desired color
OK out

 

[T. Valko]

You're welcome. Thanks for the feedback!