This question already has an answer here:
This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows:
Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green apples" and B2 also says "John likes green apples", yellow if A2 says "John likes green apples" and B2 says "Bill likes blue apples", and red if A2 says "John likes green apples" and B2 says "Bill hates red oranges".
I am just wondering if there is a way to something to that effect.
The question noted above is asking specifically for an Excel for Mac solution, so can we achieve the same thing on PC-based Excel?