hi-light every other set of columns
Worked like a charm. Thanks!
"Peter T" wrote:
One way -
=MOD(COLUMN(),4)1
Regards,
Peter T
"MarkT" wrote in message
...
Hi everyone,
I have a need to hi-light a set of two columns per set, every other set.
In
other words, columns a and b would be colored, c and d would not, then e
and
f would be colored in and so on.
I am using this conditional format formula, which is close, it does every
other column.
=MOD(COLUMN(),2)=0
Does anyone know what I need to do to the above formula to make it
hi-light
every other set of 2 colums?
I am using Excel 2007/Win XP
Thanks for your help!
|