Changing color of a row based off two values

[LostSoul3]

I don't even know if what I want to do is possible...


A > B > C > got it? > need it?

If got it and need it are "yes" then I want a b and c to be green
If got it is "yes" and need it is "no" then I want a b and c to be purple
If got it is "no" and need it is "yes" then I want a b and c to be blue
If got it and need it are "no" then I want a b and c to be red.

I saw an older post but that only colors the first box... Also if I make another rule then it just seems to cancel the other one out.. More than likely I am doing something wrong or what I am trying to do is not possible and help will be appreciated.

thanks

[Kaper]

Frank advice after http://www.excelforum.com/forum-rule...rum-rules.html :

Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
...
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

And personal add-in present few cases of data sets and "manualy obtained" desired result.

And now ... what my magic mirror says ;-) :

I can see that all you need is ... love. Yes, always, but in this case ... conditional formatting, but not standard one, but with rules based on formulas.

[Pauleyb]

if I make another rule then it just seems to cancel the other one out

This implies, to me, that you are using conditional formatting with some rules, but you just can't figure out the formula to use. I'm thinking that you are not using the AND function. It would be something like this:
=AND(got_it="yes",need_it="yes")
if that is true, then your format would be green. Similar rules for the other permutations.

[LostSoul3]

This implies, to me, that you are using conditional formatting with some rules, but you just can't figure out the formula to use. I'm thinking that you are not using the AND function. It would be something like this:
=AND(got_it="yes",need_it="yes")
if that is true, then your format would be green. Similar rules for the other permutations.

Thanks, I was entering it in wrong got it to work now .