I would like to know if I can change the font colour of a result after using an "IF" formula.
EG: If(A1>A2,[Red]"Yes",[Blue]"No")
I know the normal answer will be 'Conditional Formatting', but I have more than 3 conditions and I am using Excel 2003.
Any guidance would be greatly appreciated.
You're allowed more than 3 conditions..
It's the FORMATS that are limited to 3.
In reality, it's almost unlimited how many 'conditions' can trigger a cells font/color change.
Can you give a realistic description of what you want?
P.S.
Your profile says you're using XL2007
I can try to describe.
IF(H6>G6,[Blue]"Yes",[Red]"No") is one part and then IF(H6>G6 and E6>D6,[Green],"Yes",[Orange],"No")
In reality, I would chnage the result cell to Windings2 font so that an Up or own arrow will appear. Based on my results, the Up arrow may need to be Blue or Green and the Down Arrow may need to be Red or Orange. Thank you for assisting.
PS: I have updated my profile to show I have 2010 at home, but I am restricted to 2003 Excel at my place of employment.
In that case, you'll need a VBA solution.
Conditional formatting can only do 3 different formats.
You might be able to "save" yourself a rule by formatting all cells to a certain color, and then have teh CF change that to whatever you want/need. that way, although you only have 3 rules to play with, it makes it seem taht you have 4.
So the colors you want are...
H6>G6,[Blue]"Yes",
else [Red]"No") is one part and then
H6>G6 and E6>D6,[Green],"Yes"
else [Orange],"No")
so if you make the background color, say, blue, then you would only need rules for the other 3 colors
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks