Try a if statement

http://www.j-walk.com/ss/excel/usertips/tip010.htm

or a conditional formatting

http://www.contextures.com/xlCondFormat03.html#Errors

VBA Noob