Borders and background colors in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

A simple list of fruits with quantities and prices to demonstrate borders and background colors.

Cell	Value
A1	Item
B1	Quantity
C1	Price
A2	Apples
B2	10
C2	0.5
A3	Bananas
B3	5
C3	0.3
A4	Cherries
B4	20
C4	1.2

Formula Trace

N/A (Borders and background colors are formatting features, not formulas)

Step 1: Select range A1:C4

Step 2: Apply thick border around the range

Step 3: Apply thin borders inside the range

Step 4: Set background color of header row (A1:C1) to light gray

Step 5: Set background color of quantity cells (B2:B4) to light yellow

Cell Reference Map

Item

↓

Apples

↓

Bananas

↓

Cherries

The range A1:C4 is selected for applying borders and background colors. No formulas reference these cells.

Result

╔════════╦══════════╦════════╗
║ Item   ║ Quantity ║ Price  ║
╠════════╬══════════╬════════╣
║ Apples ║ 10       ║ 0.5    ║
╠════════╬══════════╬════════╣
║ Bananas║ 5        ║ 0.3    ║
╠════════╬══════════╬════════╣
║ Cherries║ 20      ║ 1.2    ║
╚════════╩══════════╩════════╝

The table has a thick border around all cells, thin borders between cells, the header row background is light gray, and the quantity column background is light yellow.

Sheet Trace Quiz - 3 Questions

What does applying a thick border around a range do?

A It changes the background color of the cells.

B It groups the selected cells visually with a strong outline.

C It deletes the content inside the cells.

D It adds a formula to the cells.

Key Result

N/A - Borders and background colors are formatting features, not formulas.