title: Excel: Copy cell colour from a named range to a drop down menu
body: <p>Can anyone help me? I have a named range in <code>sheet1</code> and on <code>sheet2</code> cells that reference the named range as a drop down list. I want to copy the cell colour from the named range <code>sheet1</code> when it’s selected in the drop down list <code>sheet2</code>.
  I’d be grateful for any support.</p>