You need conditional formatting. See http://www.contextures.com/xlCondFormat01.html