Presentation1.jpg

I want to be able to type a word in one cell and it highlight predetermined cells, based on the word typed. For example, if I type continental, all the items I possible could need for a contiental event would highlight. A step further, if someone types a word in O4 that is not acceptable, it would be nice if a popup would alert them as to what words are acceptable. Is this possible with excel 2007? Any help would be much appreciated!