ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Counting colored cells (https://www.excelbanter.com/excel-discussion-misc-queries/188108-counting-colored-cells.html)

Bob59

Counting colored cells
 
Is there a method for counting only cells of a certain color?

FSt1

Counting colored cells
 
hi
speaking for 2003 and back, xl has no built in function for this. however
see this site which has custom functions for this.
http://cpearson.com/excel/colors.htm

i have been told but do not know that this is built into 2007. i'm still
stuck on 2003.

regards
FSt1

"Bob59" wrote:

Is there a method for counting only cells of a certain color?


Bob Phillips

Counting colored cells
 
See http://www.xldynamic.com/source/xld.ColourCounter.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Bob59" wrote in message
...
Is there a method for counting only cells of a certain color?





All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com