IF function

G

Guest

Can I use the IF function to change the colour of a font? I'm using an IF
statement to subtract one time from another giving a positive answer. Another
in the cell below to tell me if the subtraction of the two times is over or
under zero but I'd like to highlight, automatically if it's below zero by
changing the font colour to red. Trouble is the IF statement would referance
it's own cell.
Is it possible?
 
G

Guest

It's much simpler to use conditional formatting. Select cell click format -
conditional formatting and the rest is fairly intuative.
 
G

Guest

Works a treat. Thanks very much.

Mike said:
It's much simpler to use conditional formatting. Select cell click format -
conditional formatting and the rest is fairly intuative.
Click to expand...
 

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

Similar Threads

Handling Dashes in IF statement 3
text if negative value 2
Change text colour if range of values all zero 5
Question about conditional formatting of zeros in Excel 0
Linking Equations to Highlights 2
Change the colour 1
Subtraction Function using cells with other functions in them 2
Colour using If statement 4

Top