Auto colour for matching data

[shibulal]

I have a worksheet where the T column is having the result extracted thru some formulas.

I just want to hightlight the similiar answers automatically with colours or with some patterns. Is it possible ?

If T column is : aaa

bbb

nnn

aaa

cell 1st and 4th should automatically be filled...........

 

[Faseeh]

Hi shibulal,


If you do not want different colors for each duplicated value select conditional formatting > highlight rules > highlight duplicates will fill duplicate cells with color, you need to select data first.


Regards,

Faseeh