Conditional Formatting: 3 color scale showing text relevance in Excel for Mac
Sure. Select cell B2 and go to Home tab > Styles group > Conditional Formatting > New Rule > Use formula to determine which cells to format
Enter this formula:
=AND(A2="John likes green apples",B2="John likes green apples")
Set the set the format to fill green.
Repeat for each additional color and rule.