View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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?