Apply conditional formatting rule if value is true? [Closed]

Report
Posts
2
Registration date
Tuesday February 18, 2014
Status
Member
Last seen
February 19, 2014
-
Posts
2
Registration date
Tuesday February 18, 2014
Status
Member
Last seen
February 19, 2014
-
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?

2 replies

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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
Posts
2
Registration date
Tuesday February 18, 2014
Status
Member
Last seen
February 19, 2014

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