Compare two cells value

[Mikahel369]

Hi there,

my need is to color 2 cells of the same column if they have the same value; for example:

REF	COLORTHAT
ABC	THISYES
DEF	THISNO
GHI	THISYES

thanks

[AKNiang]

You can use this formula in conditional fomatting.

Select first the range in which you want to apply the conditional formatting (in my case C3:C6)

Go to the HOME --> Conditional formatting --> New rules --> "Use formula ..:".

Paste this formula to the box--> =IF(COUNTIF($C$3:$C$6;C3)>1;TRUE;FALSE)

Click FORMAT and adjust the formatting and then press OK.

If it doesn't work get back and remove from the formula the double quotes.

✅ Check the question as solved if I helped you. 

You can follow me on LinkedIn:

(1) Abdoul Karim Niang | LinkedIn

[v-yanjiang-msft · Accepted solution]

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.

[AntrikshSharma]

@Mikahel369 Coloring cells is not possible in Power Query.

[Mikahel369]

I'll move elsewhere... if I found how to