Posted to microsoft.public.excel.programming

Stuart[_21_] Stuart[_21_] is offline

external usenet poster

Posts: 154

Chequer-box Pattern

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
colour pattern	Veeshal	Excel Discussion (Misc queries)	1	October 22nd 09 03:22 AM
calculating a pattern	jimo	Excel Discussion (Misc queries)	4	December 4th 07 10:08 PM
Get rid of pattern	smackedass	Excel Discussion (Misc queries)	1	October 1st 06 12:38 AM
Returning to 'no pattern'	dvh	Excel Discussion (Misc queries)	1	July 12th 06 07:45 PM
Pattern Formula?	sixwest	Excel Discussion (Misc queries)	3	September 13th 05 04:20 PM

All times are GMT +1. The time now is 10:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us