Showing negative values for formula results in red
 

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?

Showing negative values for formula results in red
 

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

regards
FSt1

"sherden_hershey" wrote:

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?

Showing negative values for formula results in red
 

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

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

Showing negative values for formula results in red
 

Assume the cell in question is cell A1

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

--
Biff
Microsoft Excel MVP


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

Showing negative values for formula results in red
 

This works. Thanks!!!

"T. Valko" wrote:

Assume the cell in question is cell A1

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

--
Biff
Microsoft Excel MVP


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

Showing negative values for formula results in red
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"sherden_hershey" wrote in
message ...
This works. Thanks!!!

"T. Valko" wrote:

Assume the cell in question is cell A1

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

--
Biff
Microsoft Excel MVP


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