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

B

Bob T

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

Bob Phillips

Use conditional formatting with a condition of less than 0.

--

HTH

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

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)
 
R

RODY

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
 
Top