Cond Format:re color 2 cols, skip 2 cols

[Tat]

I would like to color 2 adjacent columns, then skip 2 columns and color the
next two in a array. I can do every other column with the mod(row) formula
but I can't quite figure out how to color any number of columns, and skip a
number of columns etc.
Thanks

 

[kk]

First condition =mod(column(),4)<2
Second condition =mod(column(),4)>1



I would like to color 2 adjacent columns, then skip 2 columns and color the
next two in a array. I can do every other column with the mod(row) formula
but I can't quite figure out how to color any number of columns, and skip a
number of columns etc.
Thanks

 

[Tat]

I added +1 before the 4 in the first condition. With your formula it colored
the first column only, skipped 2 then coloured the next two, skipped 2,
colored the next 2 etc.
Thanks for your input.