LinkBack URL
About LinkBacks
Simple workbook, basically as I obtain an autograph from someone on the list I fill the cell with color. Is there a way to keep a count of cells filled with the color as I update?
Simple workbook, basically as I obtain an autograph from someone on the list I fill the cell with color. Is there a way to keep a count of cells filled with the color as I update?
You've posted in the Outlook section - shall I move the thread for you?
Be aware that you cannot count colour (or any other formatting) with a formula - it's either VBA or a different approach.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I'm so sorry, if you don't mind moving for me that would be amazing.
Thread moved to the Excel VBA section.
Ok here is my stab at it.
The macro checks if the interior color is not white so any color will be counted.
also you did say were you wanted the results so i put it on second sheet.
Here's a way using the FindFormat method.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks