Why color communicates meaning in Figma - Formula Trace Breakdown

Sample Data

This data shows business categories with their values and assigned colors to communicate meaning visually.

Cell	Value
A1	Category
B1	Value
C1	Color
A2	Sales
B2	150
C2	Green
A3	Expenses
B3	100
C3	Red
A4	Profit
B4	50
C4	Blue

Formula Trace

IF(B2 > B3, "Green", "Red")

Step 1: B2 > B3

Step 2: 150 > 100

Step 3: IF(TRUE, "Green", "Red")

Cell Reference Map

   A       B       C
1 Category Value   Color
2 Sales    150     Green
3 Expenses 100     Red
4 Profit   50      Blue

Formula references B2 and B3 to compare values.

The formula uses values from cells B2 (Sales) and B3 (Expenses) to decide the color meaning.

Result

   A       B       C
1 Category Value   Color
2 Sales    150     Green
3 Expenses 100     Red
4 Profit   50      Blue

Cell C2 shows 'Green' because Sales > Expenses, communicating positive meaning.

The color 'Green' in cell C2 visually communicates that Sales are higher than Expenses, indicating a positive outcome.

Sheet Trace Quiz - 3 Questions

What does the color 'Green' in cell C2 indicate?

A Sales are greater than Expenses

B Expenses are greater than Sales

C Profit is zero

D Values are equal

Key Result

IF(condition, "Color for TRUE", "Color for FALSE") assigns color based on value comparison.