How to make the cell or font color red if the number is negative?

[Guest]

I'd like to make a cell change color or the cell's font change color as the
number in the cell changes from negative to positive or vice versa?

 

[Bob Phillips]

Use conditional formatting with a condition of less than 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Max]

Try Conditional Formatting

Suppose you want this to happen in say, col E
Select col E
Click Format > Conditional Formatting
Make the settings as:

For Condition 1:
Formula Is| =AND(E1<>"",ISNUMBER(E1),E1>=0)
Click Format button > Patterns tab > Light green? > OK

Click Add

For Condition 2:
Formula Is| =AND(E1<>"",ISNUMBER(E1),E1<0)
Click Format button > Patterns tab > Pink? > OK

Click OK at the main dialog

Now test it out by inputting some negative, positive values, zeroes and some
text (e.g.: "ABC") in col E ..

The cells' fill color should appear accordingly for the numbers, any cell
with text entered or empty cells should not trigger the C.F. (i.e. no
formatting should occur)

 

[Guest]

Thanks Bob! That's exactly what I was looking for

 

[Guest]

Thanks Max! Your answer was very helpful, exactly what I wanted.

 

[Max]

You're welcome, Bob !
Thanks for the feedback

 

[Guest]

HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
BUTTON WOULD YOU LIKE TO DO