Color text based on value

  • Thread starter Thread starter Ron
  • Start date Start date
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.
 
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.
 
Back
Top