How to Color Alternating Rows in Excel | Scribe

    How to Color Alternating Rows in Excel

    • Adrienne Todd |
    • 4 steps |
    • 10 seconds
      1
      Click and highlight the area you would like to add alternating colours to.
      2
      In the "Home" tab, click "Format as Table."
      3
      Select a format that has alternating rows.
      4
      Specify the data range you'd like to apply the formatting to, then click "OK."