You're probably aware of this, however, what you're attempting to do can be
done by going to FormatConditional Formatting and choosing the following:

-Cell Value Is
-less than
- enter 0 in the text box
- select the format option and change the color drop down to red

One other important % tidbit... When working with percentages something
like 90% should be entered as 0.9.

"DB." wrote:

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.