Hi, I have a spreadsheet, which uses the colour of the first cell in a
column, to indicate the team that the column belongs to.

I would like to be able to select multiple columns (between B and AB)
based on the colorindex of this first cell.

For example, if the colorindex of Columns B, D, J and Z is 10, I would
like to hide all columns in the range ("B:AB") and then unhide columns
B, D, J and Z.

Example 2, if the team member in column B swaps places with the member
in Column P, then if the colorindex of Columns D, J, P and Z is 10, I
would like to hide all columns in the range ("B:AB") and then unhide
columns D, J, P and Z.

Example 3, if the colorindex of Columns F, K, L and Q is 15, I would
like to hide all columns in the range ("B:AB") and then unhide columns
F, K, L and Q.

Is there an easy way to achieve this.