Conditional Formatting!
Brilliant!
I take that back. It will only apply 3 conditional formats, and of course I have 4 to apply.

Mach - this macro seems to work by cell increments, what if the cells I want to format are not in a well thought out order? Could the macro search for any cells with the text "Good" or "Poor" and automatically update them based on the text? What if the text was the result of a cell function?