Conditional formatting based on selected cell

Hi

I have looked around for a couple of days with no real solution to this. I am trying to highlight all cells in alternating columns (B, D, F etc) that match a cell when clicked.

I have managed to get it to work in the same column where the cell is clicked, but not all columns (or preferably the alternate columns).

I am using the following as the conditional format formula
=IF(CELL("col")=COLUMN(B2:B12),B2=CELL("contents"),FALSE)

And I use
Target.Calculate in the code for the sheet.

Can anybody see where I am going wrong and show matches in all columns (B, D, F)? Any help is greatly appreciated.

Thanks

This seems to work great but how would I be able to include only every other column (in this case the Prod. column) other than explicitly defining the ranges?

Thanks so much

Hello again. I guess I am looking for a way to apply this to specific rows in every 2nd column, like:

Rows 5:10 and 12:15 in every 2nd column, starting at A for about 50 columns.

Is this possible with a For Loop?

Thanks