Brian

You could also use Conditional formatting under the format menu if your
version of Excel is XL97 or greater

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"brian" wrote in message
...
Would somebody please tell me what formula to add to an
existing formula to show and print a resultant minus
value in red when the basic formula shows results in
black The basic formula is =SUM where the cells to be
added contain both + & - values
Thanks
Brian UK