If word from list selected adjoining cell to downfill with a code
 

If a word is selected from a drop-down list, is there a formula I can use to
colour code the adjoining cell?

If word from list selected adjoining cell to downfill with a code
 

Use conditional formatting
http://www.contextures.com/xlcondformat02.html
--
Jacob (MVP - Excel)


"Mon" wrote:

If a word is selected from a drop-down list, is there a formula I can use to
colour code the adjoining cell?