Excel: Macro or Conditional formatting?

[Robertislearning]

Hello everyone,

I pull a daily report that is similar to this:

Receive Customer Response time
10:00 INR 5.0
10:15 INR 6.5
10:30 Cust 3.0
10:45 Cust 3.5
11:00 SRV 6.0
11:15 SRV 6.5

I'm trying to figure out how to have either a Macro or conditional formatting or some other tool that I'm not aware of go through a 500+ report like this and highlight any line where the 'Response Time' exceeds a pre-specified limit.

For the exmaple above, if an 'INR' customer had a 'Response Time' greater than 5.0, I would like to have that entire row highlighted in yellow. The same holds true for the 'Cust' customer with a 'Response Time' greater than 3.0 minutes.

One more action that I'd like to figure out how to build is to have any call that is greater than 15 minutes to be highlighted in red.

This will help me out tremendously as I won't have to go through each line and manually highlight each row where the 'Response Time' is exceeded. They will also be very accurate reports since I'll be removing the human error factor.

Thank you in advance for your assistance!!

 

[SkipVought]

Hi,

You can do this with Conditional Formatting.

1. Select ALL the data in ALL 3 columns
2. Conditional FOrmatting - 2 conditions (assuming that the first row of data is ROW 2 -- hence $B2 etc)

Cond 1
Formula is
=AND($B2="INR",$C2>5)

Cond2
Formula is
=AND($B2="CUST",$C2>3)

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Robertislearning]

Skip,

Thank you very much for your input. It has helped me a lot. I was able to use the same concept and apply it to my report. The problem I'm running into is that it appears that each cell can only have a maximum of 3 conditions. And if any of the three conditions is true, the other two are not applied. I have approximately 15 "Cust" names that need to be checked and formatted if necessary.

Is there any way to exceed or bypass this 3 condition limit?

Thanks in advance!

 

[bluedragon2]

take a look at thread 68-223068

Blue