User Profile
ASharp
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: sum by color when colors are set by conditional formatting
Hi Jamil, firstly thanks for taking the time to help and reply to so many members. I have read through the whole thread and cannot find the solution to my issue. Hope that you are able to help. I am trying to use your count UDF to count the number of cells conditionally formatted either red/orange/green/white as per the bottom of the table. My CF are all defined by a function, and ranges seem to match up, colours are the same as I have inputted the RGB values. I am still getting the #VALUE error in rows 136 through 138, and a 0 count in row 139. Maybe my CF rules are too complex? Thanks Aidan6.2KViews0likes3Comments
Recent Blog Articles
No content to show