"Beege" wrote:

peaspud,

Try Format/Cells/Custom

[<=1]####0.00" Meter";[1]####0.00" Meters"

Beege

Hi,
Thank you all for helping me out.
Beege your help is the one which seems to fit perfectly,bar one little hitch.
I was getting a negative answer when i had sulplus stock i.e.
Need Got Total
50 meters 65 meters -15 meters
Your formula seems to correct that. But is there anyway of getting rid of the
(1) or the (<=1) that appears in the total box (example below)
Need Got Total
25 30 (1)5.00meters

Can you use the formula with colours RED for a Negative BLUE for a Positive??
Or is that asking too much??
Thank you all again for your help
Greg