1 Reply Latest reply on Jul 10, 2018 1:55 PM by Michel Caissie

    Conditional format coloring value based on DIFFERENT field?

    Chad Clauson

      Hi,

       

      I wanted to color one of my measure values based on a value of another measure. For example, I wanted to show the number of outstanding claims. The number would then be colored based on the days late measure. How would I do that? See a below example

       

      DateOutstanding Claims
      Days Late
      7/1/20181000
      7/2/201810001
      7/3/20185002

       

      So we see on 7/1, we have 100 outstanding claims. My worksheet will show the number 100. It will color that number green since it is 0 days.

      On 7/2, the worksheet will display "1000". It will color it yellow since the value of days late is 1.

      On 7/3, the worksheet will display "500". It will color it red since the value of days late is >1.

      How would I accomplish this? I'm only familiar with conditional formatting based on the same field's value rather than referencing another measure.