Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?
Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?
See
http://cpearson.com/excel/colors.htm
In article <[email protected]>,
"Martin C" <Martin [email protected]> wrote:
> Having trouble counting cells in an excel spreadsheet that have a certain
> color only. Can anyone help?
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?
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
[email protected]> wrote:
>Having trouble counting cells in an excel spreadsheet that have a certain
>color only. Can anyone help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks