I've tried various VBA modules, but none seem to work.
I need to count, or sum the number of cells in table column, that have a background colour this is the result of conditional formatting. The cells have a '2 colour fill effect' background colour, and I'm assuming this would not be a problem. For example you just use the 1st colour of the fill effect (I'm stabbing in the dark here).
But, even when I altered the conditional formatting to use a normal 'not fill effect' background colour - none of the macros worked.
Any help would be greatly appreciated.