Use conditional formatting with a condition of less than 0.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Bob T" <Bob [email protected]> wrote in message
news:[email protected]...
> 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?
Bookmarks