You can do this with conditional formatting. You'll need to post up a sample sheet if you want specific assistance with that.

Click GO ADVANCED and use the paperclip icon to post up your workbook.