Apply conditional formatting rule if value is true?Closed

Question

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. 

Example: 

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. 

Can this be done?

Mazzaropi · Answer

apierson0, Good evening. I'm not sure if I understood correctly your doubt. Try this one: Rule 1 ---> =AND(B3="Supervisor",B4<="6:00"*1) --> Format to GREEN Rule 2 ---> =AND(B3="General Agent",B4<="8:00"*1) --> Format to GREEN Please, tell us if it worked for you. I hope it helps. -- Belo Horizonte, Brasil. Marcílio Lobão

apierson0 · Answer

I'll give this a try and see if it works, thank you!

Apply conditional formatting rule if value is true?

2 responses

Similar discussions

Subscribe To Our Newsletter!