it is easy:

1. The highlighted column depends on the selected row number
2. So you want to highlight every second column you have to multiply the
row number by 2
3. You start selection in row 2 and need column 3. So you have to
substract 1
column number = target.row *2 - 1

Regards
Claus B.


Hi Claus,

Yes, brilliant in the simplicity, I was knocking around with the OFFSET function and not getting much done.

Howard
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional