Conditional Formatting in MS Excel:

1) Select the area.
2) Click on conditional formatting.
3) Click on new rule.
4) Format only cell that contain.
5) Go to down window and define new rule.
6) Click on format button. 
7) Select the color.
8) Press ok and then ok.