How to change cell background color in numbers according to some rules?
Select the cell where you want to apply the rule. From the menu choose Format -> Show Conditional Format rules. A window opens which allows you to enter rules.

For example (this is the rule you asked for):