in menu format-cells-number-
choose whichever format for negative n;umber


Cisco wrote in message
...
Hi,

Can someone please tell me how i can get excel to format the cell when the
result is negative.

eg 2 - 3 = -1 therefore the cell would turn red.