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.
In conditional formatting I can change a cell color if there is a certin value in that specific cell, but there is no clear option of shading another cell if... show more To clarify: I'm not trying to change the color of the cell with X, but if X is present, it will change the color of another cell.n conditional formatting I can change a cell color if there is a certin value in that specific cell, but there is no clear option of shading another cell if there is a value in that cell. Update 3: Excel 2007.