Color and accessibility guidelines in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by product category used to demonstrate color and accessibility guidelines in Tableau.

Cell	Value
A1	Category
B1	Sales
A2	Furniture
B2	5000
A3	Office Supplies
B3	3000
A4	Technology
B4	7000

Formula Trace

IF [Sales] > 6000 THEN 'High' ELSEIF [Sales] > 4000 THEN 'Medium' ELSE 'Low' END

Step 1: [Sales] for Technology = 7000

Step 2: 7000 > 6000

Step 3: IF TRUE THEN 'High' ELSEIF ... END

Step 4: [Sales] for Furniture = 5000

Step 5: 5000 > 6000

Step 6: 5000 > 4000

Step 7: IF FALSE THEN ... ELSEIF TRUE THEN 'Medium' ELSE 'Low' END

Step 8: [Sales] for Office Supplies = 3000

Step 9: 3000 > 6000

Step 10: 3000 > 4000

Step 11: IF FALSE THEN ... ELSEIF FALSE THEN ... ELSE 'Low' END

Cell Reference Map

    A           B
1 Category    Sales
2 Furniture   5000  <-- referenced
3 Office Supplies 3000  <-- referenced
4 Technology  7000  <-- referenced

The formula references the Sales values in cells B2, B3, and B4 to assign categories High, Medium, or Low.

Result

    A             B       C
1 Category      Sales   Sales Level
2 Furniture     5000    Medium
3 Office Supplies 3000  Low
4 Technology    7000    High

The Sales Level column shows the result of the formula assigning High, Medium, or Low based on sales values.

Sheet Trace Quiz - 3 Questions

What Sales Level does a sales value of 7000 get assigned?

A High

B Medium

C Low

D None

Key Result

IF condition THEN result1 ELSEIF condition2 THEN result2 ELSE result3 END assigns categories based on thresholds.