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!!

arun2001mjl's avatar
arun2001mjl
Helper II
3 years ago

Thank you. Previous Badge column is calculated column which was vlookedup from another table to the main table. Since it is a calculated column, we are unable to create measure.

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    No, that shouldnt be the case even on a calculated column you can do that. If you are facing any error can you please share that error and let us know what you are facing.