human
How do I highlight every other row in Excel?
assistant
Highlight Every Other Row in Excel
1. Highlight the data you want to format.
2. Click the arrow next to "Conditional Formatting."
3. Click New Rule.
4. Select Use a formula to determine which cells to format.
5. Enter this formula: =MOD(ROW(),2)=0
6. Click Format.
7. Select a color on the Fill tab.
8. Click OK and then OK again.