Cond Format nth Column

[JudithJubilee]

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

[SteveG]

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