Cond Format nth Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You can use this for every 5th column. Select the entire range you wan
to apply the formatting to. Go to Conditional Formatting and in th
Formula is option:

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

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

HTH

Steve


http://www.cpearson.com/excel/banding.ht
 
Back
Top