title: Change background color of more than one cell on the same row when another cell has a certain numeric value in Excel 2010
body: <pre><code>    A        B        C        D
  
  1   Name     2009     2010     Total
  2   Sam      400      600      1000
  3   John     200      400      600
  4   Eric     100      300      400
  </code></pre>
  
  <p>I'm working on a simple list (see example above) where a cells background color changes (in a simple traffic light system) in both the Total (column D) and Name (column A) when the cell value in D has certain numeric values, that is:</p>
  
  <ul>
  <li>Green if total >=1000 </li>
  <li>Amber is between 500-999 </li>
  <li>Red &lt;500</li>
  </ul>
  
  <p>I've used a conditional formatting sequence using MS Excel 2010 to highlight cells in D. However, how do i create a sequence or code so that the corresponding cell in A of the same row is colored the same way? For example, if D2 is Green then I want A2 to be Green as well?</p>
  
  <p>How do i do this?</p>