Can I change the font color of text inside an IF statement?

G

Guest

Here is the equation I'm using in Excel 2003.

=IF(AND(G3="NO",B1-E3<2),B1-E3,IF(AND(G3="YES",B1-E3<=96),B1-E3,"Error"))

I would like the text color to change red if:
IF NO is selected and B1-E3 >2 I would like the text to turn red.
IF YES is selected and B1-E3 >4 I would like the text to turn red.

If I can do this in conditional formatting, that’s fine, I'm just not
familiar enough with excel to do this.

Thanks for the assistance!

Craig
 
G

Guest

Hi
a formula can't change a format.
But have a look at 'Format - Conditional Format' for this
 

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

vlookup + combo boxes, referencing... plz help :'( 1
At each color change in A1, how can B1 also change ? 2
IF function to change color of cell? 5
Formula help! 3
need a fuction that can do this (or can it be done) 3
How to make text to change its color accord. to selection from a l 2
Help!- Changing cell color 2
Moving paragraphs from MS Word to Excel 3

Top