Color text based on value

R

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.
 
A

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.
 
Top