Forum Discussion
Solved
Conditional Formatting not working with text
on one tab I have a list of names on a second tab I have a list of the names and next to them in another cell an A, B, or C ranking I want the first tab to match the name in the second tab to th...
Here is working sample
Conditional formatting rule formulae as
=INDEX($H$2:$H$5,MATCH(E2,$G$2:$G$5,0)) = "A"
Since you've created a spreadsheet with false names, why don't you post it, rather than just posting an image. That way you wouldn't be forcing us to create our own copy....we could work with your anonymous data.