View Single Post
  #2  
Old June 3rd, 2010, 05:30 AM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
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?