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" wrote in message
...
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" wrote in message
...
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