I would like to have a cell change color according to the word used in the
drop down list. (ie) drop down list has CLEAR (which would be green), CAUTION
(which would be yellow), and DANGER (which would be red). Anyone have any
ideas?