How to apply to alternate color for rows in Excel?

excel
format

#1

Hi,

Can you please help me to apply the alternate color to excel rows (please refer the below snapshot). Below, I have done it manually.

Thanks
Pravin


#2

@Pravin

You can perform this using conditional formatting option.

Step1: Select entire all cells of sheet, press Ctrl+A

Step2: Goto conditional formatting option and select New rule --> Use of formula to determine which cell to format

Step3: Put Formula, =mod(row(),2)=0 and select fill color from format button and click on OK. This formula test, if row number is even then it will change the fill color to selected one else no fill.

Here, we have alternate row filled with color.

Hope this helps!

Regards,
Imran