2018excel highlights how duplicates choose the words I want to highlight in many repeated words

2 Answers

1. +2Votes  

   Using conditional formatting…

   For example, column A marks  

   The method of not repeating data is:

   First select column A to be like this Data area made

    The menu format conditional condition condition 1 formula =COUNTIF($A$2:$A$1000,A2)=1  

    Format pattern selection A background color is determined…

   This marks the data that has not been repeated in the A2:A1000 area…

   Harold White- November 27, 2018 |

2. +1Votes  

   If the “duplicate word” Is the entire content of a cell, add the countif function in the auxiliary column, and then filter it. Otherwise, use VBA to solve.

   Cynthia Brown- November 28, 2018 |