Howdy!
I created a function that counts cells based on their background color, but it doesn't work with conditional formatting. I tried using "DisplayFormat" but that gives me an #Value! on the sheet. Does anybody know a workaround? Thanks!
Please Login or Register to view this content.
Hi, try this:
Please Login or Register to view this content.
Still getting #Value! error....
OK, thats becouse you cannot use this method in worksheet, but in Subs it works fine: https://docs.microsoft.com/en-us/off....displayformat
Right I found that too... I'm still looking for a workaround though
If the purpose is not very wide you can apply the same logic which is in conditional formatting to count trues.
That's not really an option, this code is part of a plug-in that I created for my co-workers, and they need to be able to use it everywhere.
So maybe you can use it in sub-macro and recalculate it on event (for example on any change in worksheet)?
I tried that but still gives me #Value! error
I even tried this page:
http://www.cpearson.com/excel/CFColors.htm
No success....
Example in the attachment
Right, but I need it as a function. What I tried to do was have the function call that sub, but that didn't work
You gave me an idea though, I decided to go with a button and selectables. Thanks mate!
Please Login or Register to view this content.
Possibly adapting this (counts all CF cells set to red)...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks