text: in using excel how can i change the color of a cell automatically when  the value is above a set point?   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.'