Question

How can I use Excel to change a cell's color when its value exceeds a specific threshold?

Answer 1

From the Format dropdown menu, use Conditional Formatting. Change the "between" to "greater than". Then pick the way you want the color of the Font and background (Patterns) to change when the value in the cell is greater than whatever number you put in as the 'set point.'

Answer 2

Go to Format -> Conditional Formatting and set your critieria and set your format.

Answer 3

Not sure exactly, but check out the "if" function.