Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

conditional formatting based on other column

Hi Experts,
I want to apply conditional formatting on "Activity Required Run Rate" that if -

Activity Run Rate is less than Required Run Rate then color Required Run Rate columnwith Red color.

Kindly help me how it is possible. I am trying to do it with conditional formatting but not possible for me.

Thanks

parry2k
6 years ago
Anonymous add a measure with your logic

Color = IF ( [Activity Run Rate] < [Rquired Run Rate], "Red" )

in conditional formatting, choose field value and select the above measure for color and it should work.

I would ❤Kudos 🙂 if my solution helped. ?

5 Replies

parry2k
Super User
6 years ago
Anonymous add a measure with your logic

Color = IF ( [Activity Run Rate] < [Rquired Run Rate], "Red" )

in conditional formatting, choose field value and select the above measure for color and it should work.

I would ❤Kudos 🙂 if my solution helped. ?
- Anonymous
  Not applicable
  6 years ago
  I really appriciate for quick response.
  Could you pls tell me how to color name if I want light red.
  - parry2k
    Super User
    6 years ago
    Anonymous you can use the hex value instead of actual color name. I'm sure there are many way you can get hex code of your choice of color. https://www.color-hex.com/
    
    I would 💖Kudos 🙂 if my solution helped. ?