Change color to red when fraction is negative

C

clive1950

Can anyone please tell me how to change a fraction like 14 12/1
(being 14 stone and 12Ibs - I'm british!) to red when it is
negative number only. And remain black when it is a positive

I realise it is probably easy to most but to me at 55 it seem
difficult, having tried every possibility it would seem - but not th
right one obviously :oops:

The answer to the problem would be very much appreciated
 
D

Dave Peterson

Select your cell and look at Format|conditional formatting.

Or use a custom format
Format|Cells|number tab
custom category:
[Red][<0]# ??/14;[>=0]# ??/14;General
 
Top