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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Why don't you just make this simple and upload your workbook?
ViewPic
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
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 engineered I'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)
Bookmarks