<p>As commented, just in case the link I posted there broke, try this:</p>
<p>Add a Name(any valid name) in Excel’s Name Manager under Formula tab in the Ribbon.</p>
<p>Then assign a formula using <em>GET.CELL</em> function.</p>
<p><code>=GET.CELL(63,INDIRECT("rc",FALSE))</code></p>
<p>63 stands for backcolor.</p>
<p>Let’s say we name it <em>Background</em> so in any cell with color type:</p>
<p><code>=Background</code></p>
<p><strong>Result:</strong></p>
<p>Notice that Cells A2, A3 and A4 returns 3, 4, and 5 respectively which equates to the cells background color index. HTH.</p>
<p>BTW, here’s a link on Excel’s <a href="http://dmcritchie.mvps.org/excel/colors.htm">Color Index</a></p>
