Conditional formatting on Columns based on entered value

[tarunor]

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

[Ritaf1983 · Accepted solution]

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