Showing negative values for formula results in red

S

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?
 
T

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

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
 
S

sherden_hershey

This works. Thanks!!!

T. Valko said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
Program buttons to create a word document 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Doughnut Chart linked with the slicer in the pivot table 0
Cumulative formula for word table 0
Transfer data between two tables 3
Negative value to positive 13
Newbie Help - IF Yes No Function 0

Top