Cond Format:re color 2 cols, skip 2 cols

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

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



"Tat" <[email protected]> wrote in message
news:[email protected]...
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

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.

"kk" wrote:

> First condition =mod(column(),4)<2
> Second condition =mod(column(),4)>1
>
>
>
> "Tat" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>