Forum Discussion

Mikahel369's avatar
Mikahel369
Frequent Visitor
3 years ago
Solved

Compare two cells value

Hi there,

 

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

 

REFCOLORTHAT
ABCTHISYES
DEF

THISNO

GHITHISYES

 

thanks

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

     

     

     

4 Replies

    • Mikahel369's avatar
      Mikahel369
      Frequent Visitor
      3 years ago

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

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    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.

     

     

     

  • AKNiang's avatar
    AKNiang
    Frequent Visitor
    3 years ago

     

     

    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