Conditional Color Shade Format for Each Cell in a Row in a Table

 Hello Dawg I’d recommend approaching this in three steps:

1) Add a column for each of the threshold values, this would mean adding a column for red to each  your table becomes 

2) Second step is to make a calculated column that determines the final color, this can be done using a switch statement like this:

_2024color = SWITCH(TRUE, 
    /* replace Query1 with your table name */
    Query1[2024] <= Query1[Green],"green",
    Query1[2024] <= Query1[Yellow],"yellow",
    Query1[2024] <= Query1[Red],"red"
)

since you are using two columns here, you’ll have to add one for each value you want to color.

> Note: you can also use hex colors instead of the color name 

3) Finally you can use conditional formatting to color the actual text box, select the column you want to change, enable conditional formatting, change the formatting style to “Field Value”, and set the value of “What field should we base this on?” to the calculated column we made in step 2. 

Here's a diagram of the steps

You could also use formatting to change the color of other kinds of charts if you like.