Cond Format nth Column
 

Hello All,

I want to be able to conditionally format various columns with fill at every
nth column. The 'n' will change from 5-12. I have downloaded 'asap-utilities'
which gives me that functionality, (best free utility I have found!).
However, I need to be able to to this myself. I can mess around with the
formula but it takes me awhile!

Any tutorials or suggestions on this?
--
Hope this helps

Cond Format nth Column
 

You can use this for every 5th column. Select the entire range you want
to apply the formatting to. Go to Conditional Formatting and in the
Formula is option:

=MOD(COLUMN()-1,5)+1<2

See Chip Pearson's site for more detailed explanation. He shows
formulas for rows, I just altered it for columns.

HTH

Steve


http://www.cpearson.com/excel/banding.htm


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=569590