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

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?

Use conditional formatting with a condition of less than 0.

--

HTH

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


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

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)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Bob T <Bob wrote in message
...
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?

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

"Bob Phillips" wrote:

Use conditional formatting with a condition of less than 0.

--

HTH

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


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

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

"Max" wrote:

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)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Bob T <Bob wrote in message
...
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?

You're welcome, Bob !
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Bob T" <Bob wrote
Thanks Max! Your answer was very helpful, exactly what I wanted.

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

"Bob T" wrote:

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?