xxxxxxxxxx
'Excel make Every second row colored
'Select your Range then conditional Formatting: Enter the following formula
and do the format adjustments as you desire:
'Every second ROW colored
=REST(ROW(),2)=0
'Every second COLUMN colored
=REST(COLUMN(),2)=0
xxxxxxxxxx
'Change the Number at the end to a color code.
Cells(1, 1).EntireRow.Interior.Color = 5296274
'Color Indexes / Mapping can be found here:
https://docs.microsoft.com/de-de/office/vba/api/excel.colorindex