I have 2 colums of data, A and B. Both columns contain text of either "yes" or "no". I need to format column B to fill color based on these parameters:
RED if A="yes" and B="no"
GREEN if A="no" and B="yes"
Help!? Thanks in advance.
Last edited by JuJuBe; 03-05-2010 at 11:14 AM.
Select range in column B and go to Home tab, Conditional Formatting, Manage Rules
Select use formulas to determine which cells to format...
then enter formula:
=AND(A1="yes",B1="no")
click Format and choose from Pattern tab
Click Ok.
Click New Rule
use same rule but with formula:
=AND(A1="no",B1="yes")
add select Green from Pattern tab
Click Ok
Click Ok / Apply
Note: Assumption is you are starting at B1... if you are starting lower, change A1 and B1 in formula to correspond to top row you selected to test.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thanks NBVC. I did that and had a problem when I selected and formatted the entire range. I didn't have "$" in the formula, I'm not sure what my problem was. Anyway, I tried again by only selecting and formatting B2, then copying and paste special as formats to the rest of the range and it worked. Thanks a ton for the help!
JuJuBe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks