Finding Duplicates in Excel
© Ted French
The "conditional" part of the name means that you can control when and where the formatting changes are applied. If the data meets a certain condition, then the formatting change occurs.
One common use for this feature is to find duplicate data such as duplicate names, dates, or formulas in large tables of data.
To find out all the details read the tutorial on Find Duplicates in Excel with Conditional Formatting.
Related Tutorials
I have two collums: Last Name and First Name.
I want to check to see if there are duplicated in the sheet. I am trying to get excel to highlight first and last names (together) that are duplicated. When I try it highlights all last names that are the same and all people with the same first name. I need to see if people with the same first and last name are in the sheet twice. help?
Have a new column with both first and last name you can do this by using the concatenate function or just have =cell with first name&cell with last name down that entire column, use conditional formatting on the new column. This is annoying to do but the best way to do it because thinking about it in terms of probability there will be a lower chance someone has the same first and last name. Also excel and most computer programs lack functionality and the ability to take data from 2 columns and use them in the way you want in this case. There is probably a way to do it without adding the additional column but would require some very advanced formulas and waste your time trying to figure it out. Hope this helps.
it help a lot if you are a beginner