Automatically row changes color

Hi
i am looking for a code that colors 15 rows, then the next 15 rows are a different color and so on.... i would like to also add a button to execute this and that it works on multiple worksheets in a workbook. any help on this would be much appreciated

Every 15 rows for a million+ rows?

Originally Posted by jolivanes

Every 15 rows for a million+ rows?

No, sorry should of explained it better, blocks of 15 rows 52 times each time different colour for each block

Please Login or Register  to view this content.

Two more.
Your request has a tremendous amount of possibilities so without concrete numbers it is a wild guess

Please Login or Register  to view this content.

Following has 6 different colors repeatedly used. Can be extended of course.

Please Login or Register  to view this content.

Thanks jolivanes,
it works great.. appreciate it.
Is there a way i can have it start on a particular row number eg. A17

Change the 1 (one) to 17

Please Login or Register  to view this content.

becomes

Please Login or Register  to view this content.

Fantastic...
Im just curious.. if i only want the colour the rows from column A to column P.. what would i put instead of entirerow ?

Change all the

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and remove all the ".EntireRow" wherever it appears.