Conditional formatting highlight duplicate name in sheet
Answers
Answered by
0
Select the range of cells you wish to test. One way to do so is to click on a single cell and then press Ctrl-A. On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values. Click OK within the Duplicate Values dialog box to identify the duplicate values.
Hope you get your answer!
Mark me as
Similar questions