Change color to red when fraction is negative

  • Thread starter Thread starter clive1950
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top