Excel 2003.
Can I use a worksheet function to count the number of cells in a range that have a specific fill colour?
Brianjc
You can't use an inbuilt Excel Function for this. I have written a User Defined Function that you can use, but it involves VBA code
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Try this link
I used this in Excel 2003 before I upgraded to Excel 2007
It worked fine
http://www.ozgrid.com/forum/showthread.php?t=27182
Barbara Excel
Hi,
Another solution without any code by using macro function of excel 4
Because Excel 2007 do not recognize macro excel 4, define a name with reference =GET.CELL(no_type,reference)
- no_type code 63 returns the color of the background of the cell
- reference is cell reference
See attached example
Hope this helps
Best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks