Forum Discussion
Row Background - Conditional formatting color
hello:
How can I conditional format the color in this table( in 'Descargado' column) , when the values in the ‘Descargado’ column are NO, and the values in the ‘Facturado’ column are YES.
Hi Redopel,
You can do this using conditional format.For that use this formula:
Color Descargado = IF( SELECTEDVALUE('T_CondFormat (2)'[Descargado]) = "NO" && SELECTEDVALUE('T_CondFormat (2)'[Facturado]) = "SI", "RED" )
And after go to Format --> Cell elements --> Choose Column Descargado and set the Color Descargado measure as a Background Color.
Like this:
3 Replies
Hi Redopel,
You can do this using conditional format.For that use this formula:
Color Descargado = IF( SELECTEDVALUE('T_CondFormat (2)'[Descargado]) = "NO" && SELECTEDVALUE('T_CondFormat (2)'[Facturado]) = "SI", "RED" )
And after go to Format --> Cell elements --> Choose Column Descargado and set the Color Descargado measure as a Background Color.
Like this:Very grateful, it’s what I needed
Great! If this post has solved your problem, accept my post as a solution and give it a kudo, I'll be very grateful
