Forum Discussion

Redopel's avatar
Redopel
Frequent Visitor
2 years ago
Solved

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.   ...
  • _AAndrade's avatar
    2 years ago

    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: