title: Conditional Formatting using VBA, Dynamically styling a range by referring to another cell for the formatting
body: <p>Here's my problem.</p>
  
  <p><img src="https://i.stack.imgur.com/MVxEO.jpg" alt="enter image description here"></p>
  
  <p>So, applied to the range <code>K3:K10</code>, I have several different conditional formatting rules that require a specific text string comprised of the contents of a referenced cell plus a constant text string. Each rule applies a different colour for a specific referenced cell and constant text string (DEAD or ALIVE) combination. For example, in the range, if a cell contains the word "Dog", then a space, and then the word "Dead", it will be formatted Red. The legend in columns <code>D</code> and <code>E</code> show what colours apply to each animal for the combination of criteria (Animal and Dead/Alive). What I want to do is, to be able to choose a colour for an animal with a drop down list in Column <code>C</code>, and have the CF change the formatting of any of the cells within the range <code>K3:K10</code> to match the formatting/style of the relevant row in column <code>C</code> when a particular rule is true.</p>
  
  <p>So, if <code>K3</code> is "Dog Dead", then apply the same formatting as in cell <code>D3</code> or if it is "Dog Alive" apply the same formatting as <code>E3</code>. I don't want to just ask CF to make any cell containing "Dog Dead" red or "Dog Alive" light red, because the colour for dog might not be red. It could be green, or blue.</p>
  
  <p>So, I guess I want to achieve dynamic conditional formatting using VBA I think. Can someone help me get started?</p>
  
  <p>Thanks,</p>
  
  <p>Andy.</p>