Sounds like you want Conditional Formatting http://www.xldynamic.com/source/xld.CF.html