Forum Discussion
Solved
Conditional formatting based on value in another column
Hi all, I would like to ask you for help with following issue: I have the table with 3 columns: CATEGORY TARGET PERFORMANCE 1 110% 109% 2 115% 110% 3 130% 140% And I...
Peter_2020 , Try like
if(max(table[PERFORMANCE]) <Max(Table[TARGET]) , "Red", "Green")
or
if(average(table[PERFORMANCE]) <average(Table[TARGET]) , "Red", "Green")
Peter_2020 , Try like
if(max(table[PERFORMANCE]) <Max(Table[TARGET]) , "Red", "Green")
or
if(average(table[PERFORMANCE]) <average(Table[TARGET]) , "Red", "Green")
It works!!! Thank you very much!