IF Statement

[lindzymc]

Is there anyway to have an IF statement return a value that turns the text in
the cell a different colour or font?

 

[Pecoflyer]

Is there anyway to have an IF statement return a value that turns th
text in
the cell a different colour or font?

I really don't think so without VB

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Mike H]

Hi,

yes you can do that. Consider this formula in cell A24

=IF(A1="Yes","Correct","Incorrect")

Now apply this conditional format to A24

Format|Conditional format - formula is and enter the formula

=$A$24="Incorrect"

Pick a font colur os (say) red and if the formula evaluates as Incorrect
then the text turns red.

Mike

 

[David Biddulph]

Not from an IF formula, but from conditional formatting. Look it up in
Excel help.

 

[Sheeloo]

Use the IF statement in the FORMULA IS option of CONDITIONAL FORMATTING which
allows you to choose the Formatting of the cells based on upto three
differenct conditions (upto Excel 2003, no limit in Excel 2007)

 

[JE McGimpsey]

No - functions return values to their calling cells but can't change
formatting.

However, you can use Conditional Formatting to change formats based on
the contents of the cell (including results of formulae).

Take a look at Conditional Formatting in XL Help.