Forum Discussion

Emm's avatar
Emm
Frequent Visitor
1 year ago
Solved

How to apply conditional formatting based on the Minimum column?

The Sold column in the Result is calculated measure.  How can I apply the conditional formatting to turn the cell red when the Sold column is less than the Minimum colum (fixed value) value as shown ...
Show and Tell
  • Deku's avatar
    Deku
    1 year ago

    SoldLessMin = If( [Sold] < [minimum], "Red" )

     

    Follow this guide to apply. You can replace the red string with a hex code for a particular shade of red

Emm's avatar
Emm
Frequent Visitor
1 year ago

It works.  Thank you for your help!