Counting cells based on formatting
I want to count cells based on the color that they have been formatted.
e.g. Count the number of yellow cells, count the number of green cells. Is this even possible? Thanks. |
Counting cells based on formatting
You need to use a VBA function. See
www.cpearson.com/excel/colors.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JRJ" wrote in message ... I want to count cells based on the color that they have been formatted. e.g. Count the number of yellow cells, count the number of green cells. Is this even possible? Thanks. |
Counting cells based on formatting
You can do that with excel 2007, before that you would need code
http://www.cpearson.com/excel/colors.htm on how to install http://www.mvps.org/dmcritchie/excel/install.htm otherwise the only way would be to count using some sort of criteria that you use when you color the cells if such a thing exist -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "JRJ" wrote in message ... I want to count cells based on the color that they have been formatted. e.g. Count the number of yellow cells, count the number of green cells. Is this even possible? Thanks. |
All times are GMT +1. The time now is 02:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com