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?