Forum Discussion

arun2001mjl's avatar
arun2001mjl
Helper II
3 years ago
Solved

Conditional Formatting compare with 2 Columns

Hello Team, I have mutliple columns in a table, below are the few columns on which i need conditional formatting in Badge Column.   Current Badge: Platinum Gold Silver Bronze   P...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago

    Hello arun2001mjl , create a measure and then apply that measure in the conditional formatting under field values.

    Measure looks as below:

    Conditional Formating = 
    IF(Prev_Badge = BLANK() && Badge = "Platinum","Yellow",
    IF(Prev_Badge = "Platinum" && Badge = "Platinum","White",
    IF((Prev_Badge = "Gold"||Prev_Badge = "Silver"||Prev_Badge = "Bronze")&& Badge = "Platinum", "Green", BLANK())))

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
3 years ago

Hello arun2001mjl , create a measure and then apply that measure in the conditional formatting under field values.

Measure looks as below:

Conditional Formating = 
IF(Prev_Badge = BLANK() && Badge = "Platinum","Yellow",
IF(Prev_Badge = "Platinum" && Badge = "Platinum","White",
IF((Prev_Badge = "Gold"||Prev_Badge = "Silver"||Prev_Badge = "Bronze")&& Badge = "Platinum", "Green", BLANK())))

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!