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! |
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) |