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"
Thank you so much! Since it was in google sheet I had to modify it slightly to;
=INDEX(indirect("Hires!$C$2:$C$115"),MATCH(E2,indirect("Hires!$B$2:$B$115"),0)) = "A"
being on a different tab. Super helpful, and much appreciated!!!
=INDEX(indirect("Hires!$C$2:$C$115"),MATCH(E2,indirect("Hires!$B$2:$B$115"),0)) = "A"
being on a different tab. Super helpful, and much appreciated!!!
Danimal513 , you are welcome