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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of every nth cell in a column 3
More than 3 Cond. Formats?? 4
Percentage for column 3
Cond Format -- on set of columns, then one column 3
Conditional Formatting 3
Conditonal formatting problem! 1
Delete every nth column from the worksheet 1
Trying to test for multiple of 5, or .5, .05, .005, .0005 10

Back
Top