A blog about Excel and its users
Shading your rows with alternating colors is an easy way to make your spreadsheet more legible and less confusing. There are 2 ways of doing this on Excel for Mac.
Using the AutoFormat feature completes this task, but if you end up deleting a row your spreadsheet becomes an uneven mess. AutoFormat does not automatically correct the shading to alternate every other row so you end up with 2 rows shaded next to each other - never good.
The more accurate and preferred way of shading every other row is through Conditional Formatting. Basically we are going to have Excel for Mac calculate if the row is even or odd, and shade them accordingly, so if you delete a cell the shading will shift for the entire worksheet.
And that’s how to apply a color to alternating rows in Microsoft Excel for Mac! Let us know if you have any questions or Excel for Mac tip suggestions!