Hide Columns - if they contain cells which are coloured

[jwalkerack]

Hello ,

I have a spreadsheet that contains many columns of data that contain a range of cells that either Yes or No

Set up a conditional formatting so the YES cells are coloured and the No's are not. I can do this either way round.

I was wondering if someone knows of some code to hide the rows that are coloured or / None Coloured

i have found a similar question that has been answered related to rows

vba - Excel: Hide a row if no cells in that row are colored - Stack Overflow