I have a set of data which has three columns: Persons name, profile score, engagement score.
Profile score contains a letter from a-d
Engagement score cotains a number from 1-4
I am trying to create formatting that highlights the persons name when the profile score is a,b or c AND their engagement score is 1,2 or 3. So in the end only those that are a1, a2, a3, b1, b2 , b3 are highlighted.
Any suggestions?
Bookmarks