microsoft_excel:alternative_row_colors
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| microsoft_excel:alternative_row_colors [2020/11/15 21:25] – peter | microsoft_excel:alternative_row_colors [2020/12/21 10:09] (current) – removed peter | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Microsoft Excel - Alternative Row Colors ====== | ||
| - | |||
| - | Select the entire column with the group numbers. | ||
| - | |||
| - | * Select the data range. | ||
| - | * In the Home ribbon select **Conditional Formatting -> New Rule**. | ||
| - | * Choose **Use a formula to determine which cells to format**. | ||
| - | * In the formula cell, put **=MOD($A1, 2)=1** as the formula. | ||
| - | * Click **Format**, select the **Fill** tab. | ||
| - | * Select the **Background Color** you want, then click **OK**. | ||
| - | * Click **OK**. | ||
| - | |||
microsoft_excel/alternative_row_colors.1605475551.txt.gz · Last modified: 2020/11/15 21:25 by peter