Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on other cells | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Counting based on other cells contents... | Excel Discussion (Misc queries) | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |