Skip to main content

Hello,

 

I need to format the following % change columns in red and green for positive / negative numbers.

Positive / Negative Conditional Formatting Multiple Columns in one Table 

image 

I have done this before where there is one difference column in the table.

 

imageI used logic where delta was < 0 to label as "red" else "green" and then changed the measure colours so only these two columns are actually red or green.

imageimage 

Unfortunately this won't work where there are multiple difference columns as it will always default to checking the first if statement and then format the entire row.. not just the column needed.

 

Any help or ideas?!

3 answers
0/9000