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?