hello
i search for code to count any cell is colored and put the result in m2:n so i found udf in the internet but i have fill color in coln then brings me the count in col m but i don't want to fill manually it should bring the colored and counts i put the expected result dynamically without interfere from me
B13 is same colorindex as B2:B12
Also I suggest you do not format borders as they become part of the used range...
Please Login or Register to view this content.
Last edited by Sintek; 08-12-2020 at 02:31 PM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
hi, sintek your code is perfect but i would amend the code i'm sorry about i do not mentioned that , if the colored cells contain the values should sum the values of colored cells and put the result in col n
don't have a clue what you are saying...
i put some values and i sum the values based on colored cell i do that manually you can check the file
Please Login or Register to view this content.
Last edited by Sintek; 08-12-2020 at 04:12 PM.
awesome,sintek many thanks for your codes they're work excellently
Gee...Well thanks for adding rep then ...many thanks for your codes they're work excellently
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks