I have tried to resolve this but have ended up with "ugly" solutions.
Simple enough to explain.
I have a cells in a sheet which will potentially be "coloured" depending on certain conditional formatting.
I want a solution (probably a macro) which simply "hides" any columns where the formatting is not activated.
See my example attached. If one cell is coloured then the whole column should remain visible - otherwise hide the column
Ideally, (but not mandatory) the solution should not need to examine the actual format rules. Ideally, the solution would simply KNOW that a cell has been formatted and hence remains visible.