How to add color to every odd row in Excel

[Valnurat]

I'm trying to find out how to clear colors in my spreadsheet and then add color to every odd row.

But I can't find out how this can be done. I tried to find some solutions by googled it, but I don't find what I was looking for.

Does anyone have some idea to point me in the right direction?

 

Thank You.

[water]

Please give this a try to remove the interior color of all cells:

; https://learn.microsoft.com/en-my/office/vba/api/excel.xlcolorindex
Global Const $xlColorIndexNone = -4142
$oWorkSheet.UsedRange.Interior.ColorIndex = $xlColorIndexNone

[water]

How to highlight any other row:

https://www.ablebits.com/office-addins-blog/alternate-row-colors-excel/