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

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

I really don't think so without VBA


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54303

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



"lindzymc" wrote:

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

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.



In article ,
lindzymc wrote:

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

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)

"lindzymc" wrote:

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

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

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