I have a 300,000 record file and used Excel 2007's built in conditional formatting feature to color duplicate cells. I then need to find the duplicates, so I want to sort the cells by color so I'm not scrolling through 300,000 records looking for red cells. However after installing this application and choosing to sort my column by color, I just watch Excel sit there. In fact my CPU monitor doesn't even show all that much going on on any of my 4 CPUs.
Is something wrong with the way this is working on my system, or does this product not handle sorting in the same speedy manner as the built in Excel sorts? If I were to sort by a built in criteria, Excel can sort the 300,000 records in about 3-4 seconds.
Thanks!
