Excel Shade Every Other Row How To Go About
Excel Shade Every Other Row Code In Your

Shading every other row in Excel can produce a wonderful contrast between these white rows and brighten your Excel experience.

A conditional format is the easiest way to apply these color schemes.

For example, for the ninth row, the formula MOD is (9,2).

Whereas the for the tenth row, MOD is (10,2).

Apply this formula to all rows and only MOD for odd rows returns as 1, and consequently, they are shaded.

Some people prefer Youtube tutorials to understand the process that goes into shading every other row in Excel.

The version of Microsoft Excel used in this Youtube tutorial is Excel 2013.

However, the steps remain identical across all versions of Excel, including 2013, 2016, Excel Online and the latest 2019.

The members, admins, and authors of this website respect your privacy.

The comments and forum posts are property of their posters, all the rest 2003-2015 by QD Ideas, LLC.

Excel Shade Every Other Row How To Go About

Id also like to shade the alternate row, but Im a little unsure about how to go about it.

Excel Shade Every Other Row Code In Your

You would do well to post the relevant code in your question to provide the lasting relevance were looking for at SO.

Also, note that I just picked another color for the other color stripe - you can change it to suit your needs.

Ive tried this, but unfortunately the second cell is not shaded.

Manually check on a cell that youve modified to see how many FormatConditions there are on it.

My guess is that youre setting the Interior.ColorIndex of the wrong one.

Thats essentially what I was getting at, unfortunately, I had a mixture of your conditional formatting and my explicit formatting and that was creating issues.

I would suggest you put your final code in as an answer and come back later to accept it.

Without the file directory code, I created a quick routine to shade alternate lines for only columns C, D, and E.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel excel-2013 vba or ask your own question.

Excel For Mac Shade Every Other Row