Excel =CELL("color",[Cell]) Function
<p>I guess I'm a little confused by the <code>CELL</code> function within Excel. I'm using Excel 2010 and decided to try to figure out the <a href="https://support.office.com/en-us/article/CELL-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf" rel="noreferrer">CELL function</a> as it pertains to the cells color. The documentation reads: <em>The value 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero).</em> However, the image below is what has me confused.</p>

<p><a href="https://i.stack.imgur.com/mgLvJ.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/mgLvJ.jpg" alt="Cell Formatting"></a></p>

<p>The content in the C column are the formulas, and the content in the D column are the results from the formulas. I have tried so many different formatting options (including Conditional Formatting) on this simple test, but cannot get the value of <code>=CELL("color",B1)</code> to be anything but <code>0</code>.</p>

<p>Any information on this would be much appreciated.</p>