Help with an Excel formula

[Jack Timmins]

Hey,
wondering if anyone can help me with a formula i need
it to recognise that if the answer is negative it needs to
be red. I think i need an if/then statement but do not
know how??
Eg say the formula was just simply
= F15-G15

then i need something to say if this anwer is negative
then highlight red

any help would be great

thanks

 

[Fred Smith]

Create a custom format.

Right click on the cell, choose Format Cells... On the Number tab, choose
Custom. Try one of the formats with [Red] in it. If you like it, great. If
not, you can create your own format. The rule is anything appearing before
the semi-colon applies to positive numbers; after it applies to negative
numbers.