The easiest way to accomplish this would be to use an excel add-in such as kutools, which will allow you to select cells that contain certain criteria, and then you could just format/highlight the cells once they're selected. Does lots of other things as well. See link below.

http://www.extendoffice.com/product/...ells-rows.html