title: Excel coloring cells from a named range using the ranges colors
body: <p>I would like to automatically color the cell in a column of values, based upon a named range of statuses which have the relevant color that the cell needs to pick up. For example:</p>
  
  <hr>
  
  <p>Worksheet 1</p>
  
  <p>Column A    |  Column B     |    Column C<br>
  A Name A     |     Dept AAA    |       Status 1<br>
  A Name B     |     Dept AAA     |     Status 2<br>
  A Name C    |      Dept BBB     |     Status 1<br>
  A Name D    |      Dept CCC      |    Status 3<br>
  A Name E     |     Dept BBB      |    Status 2  </p>
  
  <hr>
  
  <p>In a separate worksheet which has the named range Statuses<br>
  Worksheet 2<br>
  Column A<br>
  Status 1          (Cell colored a shade of green)<br>
  Status 2          (Cell colored a shade of blue)<br>
  Status 3          (Cell colored a shade of pink)  </p>
  
  <p>So what I want is all the Status 1's in column C of Worksheet 1 to be colored the shade of green, the Status 2's to be the shade of blue and the status 3 to be pink.<br>
  There are around 30 statuses currently colored one of four colors. These colors may change in the future and there may be additional ones therefore it should automatically pick up these colors.  </p>
  
  <p>Any help gratefully received</p>