Excel: Color cells - so it goes

1. Launch Excel on your Computer.
2. Switch to the Tab "formulas" and click "define name".
3. Now you can Designate a new formula to define this with "paint" and paste under "Refers to" the property, "=CELL.ASSIGN a(24;INDIRECT("ZS(-1)";))", if you want to include the font color.
4. You want to include, instead, the background color of the cell, you need to here are the property of "=CELL.ASSIGN(63;INDIRECT("ZS(-1)";))" insert. Save the adjustments with "OK".
5. Now add in the helper column B1, the formula "=color" and copy it down until you have reached the end of the colored cells.
6. You can see in the auxiliary column the Figures for the respective colors (3 red, for example). To count a certain color, you can use the formula "=COUNTIF(B:B;3)" the "3" defines the color to be counted.

This practical tip is based on Excel 2013 and other versions are almost identical perform. Whether you are in Excel fields are automatically colored mark can tell you in the next tip.