Forum Discussion

Anonymous's avatar
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. ...
Need Help
  • parry2k's avatar
    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. ? 

parry2k's avatar
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. ?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k 

Thank you so much for your kind support.

It works.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous woo hoo, glad to hear it worked.

     

    Cheers,
    P