formatting output of if statements

[J.F.]

Does anyone know of any way to format the output of an if statement? I'm looking to do a very simple if statement and then based on the output I want the text in that cell to come out either green (if true) or red (if false). Thanks!

 

[Vaughan]

Have a look at condional formatting on the Format menu and have a play.

 

[Andy B]

Hi

You can use Conditional Formatting for this (under Data / Conditional
Formatting). See here for an intro to it:
http://www.contextures.com/xlCondFormat01.html

--
Andy.

Does anyone know of any way to format the output of an if statement? I'm

looking to do a very simple if statement and then based on the output I want
the text in that cell to come out either green (if true) or red (if false).
Thanks!

 

[Andy B]

Sorry! CF is under Format (where else!!)