IF Statement

  • Thread starter Thread starter lindzymc
  • Start date Start date
L

lindzymc

Is there anyway to have an IF statement return a value that turns the text in
the cell a different colour or font?
 
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
 
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)
 
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.
 
You must log in or register to reply here.

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

Question about conditional formatting of zeros in Excel 0
Font 2
If Statements 1
Value if an if statement is false 3
Cell formatting and if statement 3
Font changed by Conditional Formatting 1
How do I specify text colour in an Excel function 2
Create If statement that returns a tick when true 3

Back
Top