LinkBack URL
About LinkBacks
hi all,
I have a wide table of numbers which I've sorted by some criteria, coloring the cells with specific colors.
Please see photo attached.
Is there a way to sort out on each line the number of colored cells?
many thanks!
hi all,
I have a wide table of numbers which I've sorted by some criteria, coloring the cells with specific colors.
Please see photo attached.
Is there a way to sort out on each line the number of colored cells?
many thanks!
You could use COUNTIFS based on whatever criteria you used to colour the cells.
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
thnks TMS, pls see the screenshot, I've done the =countifs ; selected range , -but as a criteria how can I impose the green colored cells? and how can I make it extrapolate how many cells are colored?
Did you colour those cells manually or by using conditional formatting? What criteria do those cells have to meet to be coloured green?
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.
Why don't you just make this simple and upload your workbook?
ViewPic
here's the spreadsheet
many thanks!
I added column A and that's where you will find the formulas.
Please Login or Register to view this content.
Compared to skywriter's solution, this looks a little over engineeredI've copied the code from Chip Pearson's download verbatim. He also has a Selection Change event handler to simulate a change event when a cell's colour is changed (this relies on a Named Range called ColorCells)
The event handler is listed here but there is too much code in the Color functions to list.
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