Conditional Formatting Only Active for Specific Column Value

[TJK]

I've created a row based conditional formatting DAX formula, but I don't want the conditional formatting to be active for the "Lender" column where Lender="COMP"

Is there anyway that I can get my formula to ignore the values that fall under "Comp" so that they are not highlighted in any colors? In other words, I only want the "RF" values to be highlighted in colors.

Below is more formula:

Color =

IF(

    NOT(ISBLANK([Transactions])),

    RANKX(CALCULATETABLE(

        ALLSELECTED('Transactions Export'[Lender])),

        [Transactions],,,Dense

    )

)

[lbendlin · Accepted solution]

Color =

IF(

    SELECTEDVALUE('Transactions Export'[Lender])<>"COMP" && NOT(ISBLANK([Transactions])),

    RANKX(CALCULATETABLE(

        ALLSELECTED('Transactions Export'[Lender])),

        [Transactions],,,Dense

    )

)