Color a Duplicate values in a particular column

Question

Hello,

Is there a straight forward way to color duplicate value in a column. All I want to do is give Green color to a TRADE ID in column G which are appearing twice and give blue color to a TRADE IDs which are appearing more than twice in column G. I have attached file having 2 sheets named as INPUT (the dataset for colouring) and RESULT (I am looking for) as example. Your help is much appreciated

Thanks

Nikhil

RAM File.xlsx

maushmisarkar · Answer

Thank you for the solution @Qiu. This is very helpful.

Is there a way to extract the data in excel format instead of using the Browse tool? Or is there a way to extract the output in excel format from the browse tool?

Thanks.

Qiu · Answer

@HULK 
I think we can use the Formula option with PCXML to achieve this.

First we will do a count for TRADE ID and store in a new column "Count".

Use the "Count" to do a conditional formatting while unchecking it from output.

0419-HULK.yxmd