Hello Everyone!,
Is there a way to count cells that have no information but are only red in color. So no text, numbers or anything symbols some cells have just been shaded in red color. If (for example) there is a column of 50 cells and 20 of them have been Filled with red then I want another cell (separate from the column of 50) to give me the number 20 (because 20 cells are red). I have tried to search around this forum but to no avail?
Thank you in advance for any help.
Margate
See: http://www.cpearson.com/excel/colors.aspx
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi Margate
I've used this Code succcessfully many times
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
or you can try this link
http://support.microsoft.com/kb/2815384
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thank you Very Much for your feedback jaslake and TMShuks. I ended up using this one: http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
Much appreciated
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks