title: Change the fill color of a cell based on a selection from a Drop Down List in an adjacent cell
body: <p>This is my first time here so I hope I'm doing things right.</p>
  
  <p>First of all, I have been investigating this for quite a while, and have found many useful tips for manipulating cell colors in Excel, but none have been able to accomplish the task.</p>
  
  <p>Here is what I need to accomplish;</p>
  
  <p>I have a table which shows a weekly class schedule for my teaching.</p>
  
  <p>In each row I have data pertaining to times, rooms, and programs. The last two cells of each row are the color code for the course and the level of the course. Let me explain below;</p>
  
  <p>In cell H8 I want to have a fill color based on the selected level from a drop down list in cell I8. (e.g. If I select "Pre-Intermediate" from the drop down list in I8 I would like the fill color of H8 to change to 'Red')</p>
  
  <p>The problem is that all the solutions I have found will only allow for a 'Yes/No' or '0/1' selection. This is inadequate for me.</p>
  
  <p>The items in the the drop down list in I8 and the corresponding color for cell H8 are;  </p>
  
  <pre><code>Elementary -&gt; Blue  
  Pre-Intermediate -&gt; Red  
  Intermediate -&gt; Green  
  Upper Intermediate -&gt; Amber  
  </code></pre>
  
  <p>I am really getting frustrated, and would greatly appreciate any assistance to find a solution.</p>
  
  <p>Thanks to all.</p>