title: How to get colors made by color scale of conditional formatting of Excel 2012 through VBA code
body: <p>I need to know: <strong>how to get colors made by color scale of conditional formatting of Excel 2010 throught VBA code</strong>. Those colors will be subsequently assigned by VBA as chart background according to the following image: </p>
  
  <p><a href="http://www.lnkm.cz/Slozka/Example.jpg" rel="noreferrer">www.lnkm.cz/Slozka/Example.jpg http://www.lnkm.cz/Slozka/Example.jpg</a></p>
  
  <p>I did a research on various web sides and:</p>
  
  <ol>
  <li>Most people advice how to read color of conditional formatting by method 
  <code>&lt;Cell&gt;.FormatConditions(index that is active).Interior.ColorIndex</code> 
  but in my case it don’t work because of error “Object doesn’t support this property or method”</li>
  <li>Some people advice to write own computation of colors (based on cells value). I found various ways how to do it, but none of them can compute same colors as was computed previously by excel (same colors as are on previous picture).</li>
  </ol>
  
  <p>So I’m asking:</p>
  
  <ol>
  <li>Is there any way to directly ready colors from cells? (or those colors are not accessible for API)</li>
  <li>Do you know how to compute same colors as excel compute?</li>
  <li>Do you know any other way how to solve my problem?</li>
  </ol>
  
  <p>I believe that it has to work somehow.</p>