Hello all! I have been searching for this answer for many days now, and I am getting quite frustrated. I'm not sure if it will work or not, but here it goes.
I am trying to add conditional formatting to statistics of call center agents. Every team has a different bracket to hit to let us know if they are in the green, yellow, or red.
I know how to use conditional formatting with formulas, but this is a little different.
The report I run and update gives them a random order, not to mention the shuffling of people between teams and promotions, etc. What I want is for a cell to know which conditional formatting rule to use based on that cell's formula.
IF B3=Supervisor, then apply conditional rule b4<=6:00 format to green.
IF B3=General Agent then apply conditional rule b4<=8:00 format to green.