Color text based on value

I seem to remember being able to do this, but can't
remember the fuction.

I want to color the text in a cell based on the value of
the text. In this case BLACK if its positive or RED if
its negative.

Thanks if advance,
Ron.

Hi

Go to Format / Cells and select Number on the left. You then get a list of
options on the right - some of which are red for negative.

--
Andy.


"Ron" wrote in message
...
I seem to remember being able to do this, but can't
remember the fuction.

I want to color the text in a cell based on the value of
the text. In this case BLACK if its positive or RED if
its negative.

Thanks if advance,
Ron.