Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hi-light every other set of columns
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hi-light every other set of columns
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hi-light every other set of columns
On Thu, 20 Mar 2008 07:55:06 -0700, MarkT
wrote: 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! Try this: =MOD(COLUMN()+?,4)<2 Replace ? with 1 or 3 to suit your needs. Hope this helps. / Lars-Åke |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
traffic light in excel | Excel Discussion (Misc queries) | |||
heavy & light gridlines | Excel Discussion (Misc queries) | |||
Excel should high-light Rows & Columns when cell selected. | Setting up and Configuration of Excel | |||
Excel 2000 too light | Excel Discussion (Misc queries) | |||
high light row your working in | Excel Discussion (Misc queries) |