Get instant live expert help on How do I shade every other row in excel

I have every other row automatically alternate colors, however, when I hid a row, it does not automatically update the color change to show every other row. Is this possible?

Would like formula that adds content in cells on every other row

Hello- I have created a schema to convert excel to XML, but when I populate the data under the column headings, every other row is highlighted in blue- ?

i am using a macro in excel to sort data that is being imported from csv i am wondering can i add on to the macro to conditional format each row to a shade if they are grouped together by the same data in a column example column A will have a full name of a person and I would like it to format it in a grey shade and once a new name comes up leave it white and then when the next name go back to grey or if needed another shade

I want to know how to color every other row, like an accounting ledger.