Yes it's simple. So simple that simple me cannot see it.

Whilst setting the pattern is simple, finding an efficient way
to determine which cell requires which pattern .... that is
more difficult for me.

Do I really have to cycle across "A1:Z1" alternating the pattern and then
repeat for each row ( or via sequential
columns)?

I was hoping there might be some more efficient way.

Regards.


"Mark" wrote in message
...
Something as simple as that might be best done through manually recording
the
macro rather than actually coding anything yourself.

"Stuart" wrote:

With the range ("A1:Z100") in the activesheet, I would like to create
alternating patterns in the cells using
ColorIndexes 2 and 15.
So A1=2 B1=15 C1=2
And A2=15 B2=2 C2=15 etc

How best to do this, please?

Regards.