![]() Highlight duplicate cells except first occurrences To highlight unique cells, pick Unique in the left-hand box.Įxample 2.To apply your own formatting for duplicates, click Custom Format… (the last item in the drop-down list), and then choose the desired Font, Border and Fill options.Excel will show you a preview of the selected format right away, and if you are happy with it, click OK. In the Duplicate Values pop-up dialog, choose formatting for Duplicate cells (the default is Light Red Fill and Dark Red Text). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |