Скачать или смотреть SUM/COUNT/IF Cells Based on Color in Excel - Includes Conditional Formatting

Excel File: https://www.teachexcel.com/excel-tuto...
Excel Forum: https://www.teachexcel.com/talk/micro...

Use Cell Color to SUM, COUNT, use IF statements, and more in Excel - including Conditional Formatting colors.

This tutorial walks you through every step that you need to take to use cell color in formulas in Excel. The included files, provided in the link above, contain all macro code that is needed to add this feature to Excel and this tutorial covers not only how to use the macro, but also how to change it for your needs.

Excel doesn't make this, seemingly simple, feature available by default, but, after viewing this tutorial, you will be able to implement it into any workbook or spreadsheet that you have.

If you have any questions, make sure to ask here or in the forum, linked to above here, where you can upload sample files.

Enjoy!
TeachExcel.com