In cell A10 I have the value of my shares at close yesterday
(£1000 -cell formatted in £).
In cell B10 have the value of my shares at close today (£1050 -cell
formatted in £).
In cell C10 I have today's gain =(B10-A10) -formatted in £ to appear
RED if the 'gain' is a loss.
In cell D10 I have today's gain shown as a percentage i.e.
=(B10-A10)/A10 formatted as a percentage.

This is all very well if I've made a gain today - the percentage figure
in D10 appears in black. If I've made a loss the percentage figure
appears in black with a minus sign in front of it. Is there any way I
can arrange for this loss% to appear in red? It surprises me that
whilst negative numbers and sums can readily be made to appear in red
negative percentages cannot.

I'm using Excel 2003. TIA of any reply.

--
DB.