Alternating row colors in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing a team attendance sheet.

📋 Request: Your manager wants the attendance sheet to be easier to read by adding alternating row colors.

📊 Data: You have a list of employees with their attendance status for each day of the week.

🎯 Deliverable: Create a Google Sheets attendance table with alternating row colors for better readability.

Sample Data

Employee	Monday	Tuesday	Wednesday	Thursday	Friday
Alice	Present	Present	Absent	Present	Present
Bob	Absent	Present	Present	Absent	Present
Charlie	Present	Absent	Present	Present	Absent
Diana	Present	Present	Present	Present	Present
Edward	Absent	Absent	Present	Absent	Present
Fiona	Present	Present	Absent	Present	Absent

1

Step 1: Select the range of your attendance data including headers (A1:F7).

Click and drag from cell A1 to F7 to select all data.

Expected Result

The entire attendance table is highlighted.

2

Step 2: Open the 'Format' menu and choose 'Alternating colors'.

In Google Sheets menu, click Format > Alternating colors.

Expected Result

A sidebar appears on the right with alternating color options.

3

Step 3: In the sidebar, make sure 'Header' is checked to keep the header row color distinct.

Check the box labeled 'Header'.

Expected Result

The header row remains a solid color different from the alternating rows.

4

Step 4: Choose a light color for the first row color and a white or very light color for the second row color.

Select colors like light gray and white from the color picker.

Expected Result

Rows alternate between light gray and white for easy reading.

5

Step 5: Click 'Done' to apply the alternating row colors to your attendance table.

Press the 'Done' button at the bottom of the sidebar.

Expected Result

The attendance table now shows alternating row colors, improving readability.

Final Result

Alice

↓

Bob

↓

Charlie

↓

Diana

↓

Edward

↓

Fiona

✓Alternating row colors make it easier to follow each employee's attendance across the week.

✓The header row stands out clearly from the data rows.

✓This formatting reduces eye strain when scanning the table.

Bonus Challenge

Use a custom formula in conditional formatting to highlight all 'Absent' cells with a red background.

Show Hint

Use the custom formula =A2="Absent" in conditional formatting applied to the data range.