I created a workbook with several worksheets. They connect to one worksheet that has several of the same drop down lists on it. I want to be able to find duplicates on the page when the same selection is used in the range I choose. I found how to do that and it works. However I could find no help on how to resolve one problem I encountered. The drop down lists have the same first entry, so when I highlight duplicates on the page all the first entries are highlighted on the worksheet. ![Oops! :oops: :oops:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I spent a lot of time working with conditional formatting to no avail. I also looked on line and tried most of the formulas that looked like they would work, but to no avail.
The conditional formula I used is:__
=COUNTIF($C$3:$L$8,C3)>1
The first names in the drop down lists I do not want highlighted are: "Name" and "Staff Names" .
Is there a way to keep the first items in a list from being highlighted on the page. That way when users select the other items with a specific range and they are duplicates they will stand out without having all the highlighted first items also showing on the worksheet.
Thank you.
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I spent a lot of time working with conditional formatting to no avail. I also looked on line and tried most of the formulas that looked like they would work, but to no avail.
The conditional formula I used is:__
=COUNTIF($C$3:$L$8,C3)>1
The first names in the drop down lists I do not want highlighted are: "Name" and "Staff Names" .
Is there a way to keep the first items in a list from being highlighted on the page. That way when users select the other items with a specific range and they are duplicates they will stand out without having all the highlighted first items also showing on the worksheet.
Thank you.