SoftMaker.com

Hi Volker, Thanks for your reply. Changing the format is not the problem. I can achieve the same results with the Conditional formatting (changing duplicates to red). The problem is sorting. I want to sort the 'Red' cells so they are at the top. Is there any way to sort on the cell color? Microsoft ...

I have an Excel file with 35,000 rows. One column contains names. I want to sort on duplicate items (i.e. put duplicate items at the bottom). In Excel I could do this easily by Conditional Formatting -> Highlight Dupes, then sort on color. Plan maker does not appear to have this ability. Is there a ...