Conditional formatting in tables in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows products and their sales numbers.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	120
A3	Bananas
B3	80
A4	Cherries
B4	150
A5	Dates
B5	60

Formula Trace

IF([Sales] > 100, "Green", "Red")

Step 1: [Sales] for Apples = 120

Step 2: 120 > 100

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

Step 4: [Sales] for Bananas = 80

Step 5: 80 > 100

Step 6: IF(FALSE, "Green", "Red")

Step 7: [Sales] for Cherries = 150

Step 8: 150 > 100

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

Step 10: [Sales] for Dates = 60

Step 11: 60 > 100

Step 12: IF(FALSE, "Green", "Red")

Cell Reference Map

    A        B
1 |Product | Sales |
2 |Apples  | 120  | <-- Sales value used in formula
3 |Bananas | 80   | <-- Sales value used in formula
4 |Cherries| 150  | <-- Sales value used in formula
5 |Dates   | 60   | <-- Sales value used in formula

The formula uses the Sales column values from cells B2 to B5 to decide the color.

Result

    A        B        C
1 |Product | Sales | Color  |
2 |Apples  | 120   | Green  |
3 |Bananas | 80    | Red    |
4 |Cherries| 150   | Green  |
5 |Dates   | 60    | Red    |

The Color column shows Green if Sales > 100, otherwise Red.

Sheet Trace Quiz - 3 Questions

What color will the product 'Cherries' have based on the formula?

A Green

B Red

C Yellow

D Blue

Key Result

IF(condition, value_if_true, value_if_false) sets color based on a sales threshold.