M Mon Jun 3, 2010 #1 If a word is selected from a drop-down list, is there a formula I can use to colour code the adjoining cell?
If a word is selected from a drop-down list, is there a formula I can use to colour code the adjoining cell?
J Jacob Skaria Jun 3, 2010 #2 Use conditional formatting http://www.contextures.com/xlcondformat02.html