Color text based on value

[Ron]

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.

 

[Andy B]

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.