If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I change the font color of text inside an IF statement?
Here is the equation I'm using in Excel 2003.
=IF(AND(G3="NO",B1-E32),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 |
#2
|
|||
|
|||
Hi a formula can't change a format. But have a look at 'Format - Conditional Format' for this "Craig_I" wrote: Here is the equation I'm using in Excel 2003. =IF(AND(G3="NO",B1-E32),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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need to combine a fixed text statement to a variable text state. | Eddie Crocker | General Discussion | 2 | September 28th, 2004 03:57 PM |
Change Default Font. | Richard Gutery | General Discussion | 2 | September 23rd, 2004 11:43 AM |
Change Font in continuous form? | Bob | General Discussion | 1 | August 27th, 2004 02:58 AM |
Cannot change font or font size in new mail | George | Outlook Express | 1 | August 21st, 2004 01:00 AM |