Is there a way that when i enter in a value, lets say a1:a10 adds up and is a
negative number in cell a11. is there way to make that value automatically be
red?
Also is there a way not only to do numbers but also letters.
W.H.

You could use format|conditional formatting for numbers or letters (the whole
cell--not character by character).

Or for negative numbers, you could use a custom format:

0;[Red]-0;0;@

The four parts a positive;negative;zero;text



MbeSailor wrote:

Is there a way that when i enter in a value, lets say a1:a10 adds up and is a
negative number in cell a11. is there way to make that value automatically be
red?
Also is there a way not only to do numbers but also letters.
W.H.

--

Dave Peterson