ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I find duplicate text enteries in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/38652-how-do-i-find-duplicate-text-enteries-excel.html)

Cambronze

how do I find duplicate text enteries in Excel
 
What I am trying to do is use a list of products in my spread sheets. When
an item is duplicated under another heading then I want to highlight it

Bob Phillips

Use conditional formatting. Look at 'Highlight cells that meet specific
conditions' in the Answer wizard in help


--
HTH

Bob Phillips

"Cambronze" wrote in message
...
What I am trying to do is use a list of products in my spread sheets.

When
an item is duplicated under another heading then I want to highlight it





All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com