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 T@discussions.microsoft.com> wrote in message
> news:995EE172-AAE8-46EE-ADB4-5DF46F9D3806@microsoft.com...
> > 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?
>
>
>