font colour change within a IF formula - Help!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an IF formula and need to change the font colour of the FALSE value to
red - how do I do it?????? Help!!!!
 
check out conditional formating in Help.

If you mean in the equation itself, I do not think you can do it.
 
Andy

Couple of ways: Conditional Formatting is one:

go to FORMAT/Conditional Format and set it up so that if the answer to
the calculation is less than 0, the formatting will turn the font red.


You can do the same thing with the normal Format function, but the
conditional formatting gives you the chance of colouring the background
and all sorts of other goodies

Enjoy
Jon
 

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

FONT COLOUR CHANGE 3
Change cell font color if time is> by 15 minute intervals upto 2hr 5
auto change cell text colour resulting from a condition 2
Changing the font of a cell dependant on the outcome 1
Change the colour 1
Highlighting dates in a cell relative to the TODAY() 3
Change text colour if range of values all zero 5
conditional formatting update issue 5

Back
Top