My formula is =IF((C2+E2)>D2,"WIN","LOSE") Could some one please tell me the new formula if I wanted the cells with "WIN" to be green, and the 'LOSE' cells to be yellow. Excel 2010
Thanks in advance
My formula is =IF((C2+E2)>D2,"WIN","LOSE") Could some one please tell me the new formula if I wanted the cells with "WIN" to be green, and the 'LOSE' cells to be yellow. Excel 2010
Thanks in advance
Hi,
You would need this to be done using Conditional Formatting, as you can't change cell colour using a cell formula.
In the conditional formatting, select "New Rule", then "Format only cells that contain". Choose "Cell Value", "equal to", "WIN" (without the quotation marks).
Repeat this for "LOSE".
Hope this helps
Hi and welcome to the forum
follow ajryan's instructions to apply the Conditional Formatting, but they left out the actual formula...
for the 1st rule (equal to)...
=C2+E2>D2
for the 2nd rule (Lose)
=C2+E2<=D2
Highlight the entire range you want the CF to apply to, before you go into the CF window
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
@FDibbins: you don't need a formula if you choose "Format only cells that contain", you only need to provide a cell value, which is either "WIN" or "LOSE"
aahhh yes, good point aj, I should have read your post properly
Thank you guys!! Problem solved!!!
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks