Fill color in every alternate row in Excel - Shortcut

In this tutorial I’ll show you how to fill color in every alternate row in Excel or how to highlight every alternate row in Excel.

If you have small data and you want highlight or fill color in every alternate row then it take less time to do manually. But what if you have more than hundreds or thousands of row then it will be very time consuming. Thus in this post I’ll show you how to highlight every alternate row easily and that too without consuming much time.

Lets Start -

We are going to use Conditional formatting Rule to highlight alternate Row.

First select all Data then go to Conditional Formatting and select New Rule.

We have to create new Formatting rule. Select a last Rule Type “Use a formula to determine which cells to format” and in Edit the Rule Description field type formula “=mod(row(),2)”.

After typing formula click on Format button and select format which you want. Here I have select Bold Font and Fill Orange Color in Format Cells window.

Then click on Ok button. Now you can see all alternate row change in format you choose.

Hope you understand how to Fill color in every alternate row in Excel.

If you have any issue then feel free to comment on Post.

Have a nice day…. Enjoy Excelling …..