excel中一列中查找重复

Excel中一列数据，查找中间的重复项:

1. select the column which you want to search duplicate value

2. Home->Conditional Formatting(locate in styles)->HighLight Cells Rules->Duplicate Values...->Light Red Fill with Dark Red Text->OK