Alternating row colors in Google Sheets - Dashboard Guide

Dashboard Mode - Alternating row colors

Goal

Make a table easier to read by coloring every other row with a light background color.

Sample Data

Item	Category	Price
Apple	Fruit	1.20
Carrot	Vegetable	0.80
Banana	Fruit	1.10
Broccoli	Vegetable	1.50
Orange	Fruit	1.30
Spinach	Vegetable	1.00

Dashboard Components

• Data Table: The table with items, categories, and prices.
• Alternating Row Colors: Use Google Sheets built-in feature: Select the data range (A2:C7), then Format > Alternating colors. Choose a light gray for even rows.
• Formula for Conditional Formatting (optional): =ISEVEN(ROW()) applied to the range to color even rows.

Dashboard Layout

+-----------------------------+
|        Data Table           |
|  (with alternating colors)  |
+-----------------------------+

Interactivity

The alternating colors update automatically if you add or remove rows in the table. The color pattern stays consistent because it depends on the row number.

Self Check

Add a new row with a new item below the last row. Does the new row have the correct alternating color? Yes, it should follow the pattern automatically.

Key Result

A simple table with alternating row colors to improve readability.