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

apierson0 2 Posts Tuesday February 18, 2014Registration date February 19, 2014 Last seen - Feb 18, 2014 at 04:04 PM - Latest reply: apierson0 2 Posts Tuesday February 18, 2014Registration date February 19, 2014 Last seen
- Feb 19, 2014 at 10:30 AM
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?
See more 

2 replies

Mazzaropi 1751 Posts Monday August 16, 2010Registration dateContributorStatus February 22, 2018 Last seen - Feb 18, 2014 at 09:19 PM
0
Helpful
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 2 Posts Tuesday February 18, 2014Registration date February 19, 2014 Last seen - Feb 19, 2014 at 10:30 AM
0
Helpful
I'll give this a try and see if it works, thank you!