title: conditional formatting for background color using VBA?
body: <p>I got VBA code to populate some T-SQL query data in an Excel file. In that data, one column contains values of Red, Amber, Green and N/A. Now I want background Color for according to those values (Red, Amber, Green and White). How can I do this in VBA?</p>
  
  <p><strong>Edited:</strong> I need Like this:</p>
  
  <pre><code>id firstname lastname complaint
  1  paul      nixon    RED
  2  John      nathon   RED
  3  sera      teag     AMBER
  4  CLARE     walker   GREEN
  </code></pre>
  
  <p>Now I want background color for column 'complaint' according to cell value, like if cell value RED I want that background color also RED etc.. in VBA code.</p>