Compare two cells value

Hi Mikahel369 ,

According to your description, here's my solution.

Create a measure.

Color =
IF (
    COUNTROWS (
        FILTER ( ALL ( 'Table' ), 'Table'[COLORTHAT] = MAX ( 'Table'[COLORTHAT] ) )
    ) > 1,
    "Red"
)

In the visualizations pane, select the drop-box of COLORTHAT, then click Conditional formatting>Font color.

Select the measure in the dialog.

Get the expected result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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