
Conditional formatting is common method for this. You create rules that use formulas to determine which cells get formatted. In this case you would need three rules, each with a formula that evaluates to TRUE only for those cells whose data qualifies for each color.