Forum Discussion

tarunor's avatar
tarunor
New Member
3 years ago
Solved

Conditional formatting on Columns based on entered value

Hi team, 

I want to add a value entering field at the top, so if we enter any value there, difference column above the entered value gets highlighted.

 

Is there any way I could do that?

 

Thanks in advance

  • Hi tarunor 
    You can use the parameters feature for this.
    1. Modify parameter according to your needs

     

    2. create flag measure for highlighting :

    condition = if([sum]=Parameter[Parameter Value],1,0)
    3. use this measure as a condition on conditional formatting:

     

    Link to the sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

1 Reply

  • Hi tarunor 
    You can use the parameters feature for this.
    1. Modify parameter according to your needs

     

    2. create flag measure for highlighting :

    condition = if([sum]=Parameter[Parameter Value],1,0)
    3. use this measure as a condition on conditional formatting:

     

    Link to the sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly