You would use Conditional Formatting:

See this link for help:

http://www.contextures.com/xlCondFormat01.html