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
For the first one, let's assume that cell D2 is the first cell that needs conditional formatting. You might use formulas like:
=D2<0.85 for the red format
=AND(D2>=0.85, D2<0.92) for the yellow format
After entering the formula, click the Format button, go to the Fill tab and choose your color. Click OK twice.
For the second one, you might use a criteria like:
=AND(COUNT(B2:C2)=2, (C2-B2)>=TIME(0,5,0)) for the red format