by Kara Hiltz
Worksheets often span hundreds or thousands of rows, which can wreak havoc on your eyes. Alternate row shading makes it easier to read large data tables, but if you manually shade rows, any changes you make to the data later will cause problems with your shading.
Here’s a quick way to apply row shading to every other row in your data using conditional formatting. Just follow these steps:
- Select the data range to which[…]