Select the cell or cells that you want to shade. go to FORMAT-CONDITIONAL
FORMATING. Use the drop down box to choose greater than or equal to, in the
right most box enter the value Click the format button to pick the shading
you want. Click Okay and you are done.

Formula example

"Rafi2288" wrote:

I want to create a formula where a cell will automatically be shaded a
certain color if a number is = a certain number