Alternate Colors

  • Thread starter Thread starter Mark G.
  • Start date Start date
M

Mark G.

Is there a way that if I select a range of lets say 140 rows and then want
to change the colors from white to something else that I could make it where
one row is one color while the next is another and then soforth with a
combination of maybe 2-4 colors or something. Even just alternating between
just 2 colors? If not built in, then is there a trick or script or something
that someone has that could assist with something like this? Would be much
appreciated. Thanks.
 
Hi Mark

One way would be conditional formatting. Select the whole sheet by pressing
Ctrl+A
Format>Conditional Formatting>select Formula is from dropdown
In White pane type =MOD(ROW(),2)=0 for every other row
Format choose Patterns then the colouring you want
Click Add and repeat for
=MOD(ROW(),3)=0 for every third row, with a different colour.

Regards

Roger Govier
 
You must log in or register to reply here.

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel VBA - Problem with Closing Print Preview 0
How to shade groups of rows in excel. 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
conditional formatting with color- five rows at a time? 1
Windows 7 Default page color for e-mail (Outlook) 1
Excel VBA 1
conditional format - table - cell empty return default color 1

Back
Top