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?