Conditional Formatting: Duplicates and Uniques

ctopp

New Member
Joined
Sep 5, 2014
Messages
4
I am comparing two large documents side by side. After trying different options, I found that the best way for me to do this was to highlight one data set grey, stack the two data sets, and then sort by one of the values. I then used conditional formatting to highlight the cells which were "unique" so that I could see what changed. I thought it was working great until I noticed a cell that the conditional formatting didn't catch. After finding others, I then used conditional formatting to highlight all the duplicate cells. Everything should be highlighted now (some unique, some duplicate). Yet half my document isn't highlighted at all. What gives?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
It sounds like the two data sets could be compared with using countif or vlookup instead of a Conditional Format. Is there a common field/column of data between the two data sets?
 
Upvote 0
There is nothing between the two sets that perfectly matches because some rows have been added/taken away.
 
Upvote 0
There is nothing between the two sets that perfectly matches because some rows have been added/taken away.
 
Upvote 0
Like, is there one word in one of the tables that is the same in the other table? Sure. Some are identical and some have changed.
 
Upvote 0

Forum statistics

Threads
1,226,287
Messages
6,190,069
Members
453,593
Latest member
Mubashar Ali

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top