troubleshooting Question

Excel Conditional Formatting

Avatar of Dave KIlby
Dave KIlby asked on
Microsoft Excel
5 Comments1 Solution49 ViewsLast Modified:
I have two conditional formatting questions

1 - I have a column with percentage values, If the percent is less than 92% but greater than 85% i want the background to be yellow, and then if it is less than 85% the background would be red.

2 - I have 2 columns B & C that have time values - I want to compare C to B and if C is great than B by 5 mins then the background would be red - example Column B = 9:00:00, Column C = 9:06:52.  Column C background would be red

How can I accomplish this?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros