Are you in search of real estate in Provo? Provo is located about 50 miles south of Salt Lake City along the Wasatch Front, and lies between the cities of Orem and Springville.re you in search of real estate in Provo? Provo is located about 50 miles south of Salt Lake City along the Wasatch Front, and lies between the cities of Orem and Springville.
Best Answer: Select the cell you want to change colour. Go to: Format > Conditional Formatting > Select: Formula is: =B4>=10. Select Format to choose the special colour. Whenever the value in B4 gets higher than or equal to 10, the specially formatted cell(s) will change colour.
This formula will change the back color of Cell B1 to green if the value is from 1 to 10. 8. To change the back color of Cell B1 to Blue if the value is from 11 to 20 repeat steps 1 through 6, only change the formula in step 5 as: =AND(11<=$B$8, $B$8<=20)=TRUE. Also select the Fill Color as Blue.