How do you alternate column colors in Excel?

Answer 1

Click inside the range you want to color. On the Home tab, in the Styles group, click Format as Table. If you click the drop-down, you will see color choices organized into light, medium, and dark color sets.