The easiest way to implement that is using Conditional Formatting. It doesnot require VBA, it is built in to Excel. The way to do this differsdepending on the version of Office you have.