Hi
If I have a cell, A3, containing the formula '=A1+A2', is it possible to make the font of the cell change colour if the answer is negative?
ie. if A1+A2 = +5 then A3 will display '5' in black ink
if A1+A2 = -5 then A3 will display '5' in red ink
Many thanks
Johno