title: Excel data validation: Change fill color without changing text
body: <p>I have a floor plan with about 50 resources that either need to be marked available, reserved, or occupied.  I chose to use data validation in-cell drop-down list for each resource.  Is it possible to keep the text in the data validation cell, use the source as the drop-down options, and change the fill color based on the selection?  That might be hard to understand so I'll provide an example.</p>
  
  <p><strong>Example given:</strong></p>
  
  <p>A1:A3 is the source with Available, Reserved, and Occupied.</p>
  
  <p>Cell D3: Available, Reserved, and Occupied as drop-down list, the fill color will change to green, orange, or red respectively, and it will keep the text in the cell.</p>