Conditional formatting based on column values

^{Hi Anonymous97 ,}

^{Please follow these steps:}

^{(1) Create a new measure}

condition2 = 
IF (
    [Measure2]
        = MAXX (
            FILTER (
                'Table',
                [Measure1]
                    = MAXX (
                        FILTER (
                            ALL ( 'Table' ),
                            [lend] = MAX ( 'Table'[lend] )
                                && [Measure1] < [Parameter Value]
                        ),
                        [Measure1]
                    )
            ),
            [Measure2]
        ),
    "#118DFF"
)

^{(2) The end result}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}