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.
How to change a cell's color based on a value of another cell. In fact, this is simply a variation of changing the background color of a row case. But instead of the whole table, you select a column or a range where you want to change the cells color and use the formulas described above. For example, we could create three such rules to shade only the cells in the Order number column based on another cell value (values in the Delivery column).