font colour change within a IF formula - Help!!
 

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.

"Andyp" wrote:

I have an IF formula and need to change the font colour of the FALSE value to
red - how do I do it?????? Help!!!!

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


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=399024