I guess I'm a little confused by the CELL function within Excel. I'm using Excel 2010 and decided to try to figure out the CELL function as it pertains to the cells color. The documentation reads: The value 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero). However, the image below is what has me confused.

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 =CELL("color",B1) to be anything but 0.

Any information on this would be much appreciated.

1 Answer

Documentation says:

The value 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero).

An example of a format that would generate a "1": Right click a cell -> Format Cells -> Select Number -> Choose the second format where the negative number appears in red.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy