Try Conditional formatting (see link) and use
http://www.contextures.com/xlCondFormat01.html

=$A1="good"
Link below has useful links including video links etc

VBA Noob