Highlight rows which have the same entries

[YasserKhalil]

Hello everybody

I have three columns A , B and C.
I want to highlight the rows that have the same entries regardless the order of them

For example In Row 1 : cat - dog - fish
In Row 7 : dog - fish - cat

These two rows have to be highlighted....

 

[FawnCC]

You could use conditional formatting.
Depending on how you want it to show up will dictate how hard it is to program. Did you only want it to highlight specific combinations or did you want all combinations defined and highlighted in different colors?

 

[YasserKhalil]

I want all combinations defined ....

I really want to use formulas to refer to the same entries .. Is it possible?

 

[FawnCC]

With alll combinations defined you can use conditional formating to highlight the different combinations.

What do you mean you want formulas to refer to the same entries? Do you want like a countif(s) to get a number of entries for each combination or do you want something else?