| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?
Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help? |
|
#2
|
|||
|
|||
|
See
http://cpearson.com/excel/colors.htm In article , "Martin C" <Martin wrote: Having trouble counting cells in an excel spreadsheet that have a certain color only. Can anyone help? |
|
#3
|
|||
|
|||
|
Hi Martin
Basically it can't be done by Excel in its normal configuration. However, have a look at the site below for adding ColourIndex to Excel, which will then allow you to count cells and other interesting stuff. www.xldynamic.com/source/xld.ColourCounter.html HTH Michael Mitchelson "Martin C" wrote: Having trouble counting cells in an excel spreadsheet that have a certain color only. Can anyone help? |
|
#4
|
|||
|
|||
|
Martin
How were the cells colored? If by using Conditional Formatting, count on those conditions. If manually colored, you will need a User Defined Function. See Chip Pearson's site for code. http://www.cpearson.com/excel/colors.htm Gord Dibben Excel MVP On Thu, 28 Jul 2005 14:33:03 -0700, "Martin C" <Martin wrote: Having trouble counting cells in an excel spreadsheet that have a certain color only. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count # of cells b/w cells ... | Excel Discussion (Misc queries) | |||
| count cells that have *text1* and don't have *text2* | Excel Discussion (Misc queries) | |||
| Count cells in a column that contain dates | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| How do I count shaded cells | Excel Worksheet Functions | |||
Linear Mode
