Article: You can usually do this by double-clicking the file on your Mac. Click and drag the mouse to select all the cells in the range you want to edit. If you want to highlight every other row in the entire document, press Command+A on your keyboard. This will select all the cells in your spreadsheet. " You can find this button on the Home toolbar at the top of your spreadsheet. It will expand your formatting options. This will open your formatting options in a new dialogue box, titled "New Formatting Rule." Click the Style drop-down in the pop-up window, and select Classic at the bottom of the menu. Click the drop-down below the Style option, and select the Use a formula option to customize your formatting with a formula. Click the formula field in the New Formatting Rule window, and type the following formula: =MOD(ROW(),2)=0 This option is located below the formula field at the bottom. It will expand your formatting options on a drop-down. The formatting you select here will be applied to every other row in the selected area. You can click an option here, and preview it on the right-hand side of the pop-up window. If you want to manually create a new highlight format with different color, click the custom format... option at the bottom. It will open a new window, and allow you to manually select fonts, borders and colors to use. This will apply your custom formatting, and highlight every other row in the selected area on your spreadsheet. You can edit the rule at any time by clicking the arrow next to Conditional Formatting (on the Home tab), selecting Manage Rules, and then selecting the rule.

What is a summary?
Open the spreadsheet you want to edit in Excel. Select the cells you want to format. Click the icon next to "Conditional Formatting. Click New Rule on the Conditional Formatting menu. Select Classic next to Style. Select Use a formula to determine which cells to format under Style. Enter the formula to highlight alternating rows. Click the drop-down next to Format with. Select a formatting option on the "Format with" drop-down. Click OK.