Forum Discussion
ravimistry1
Mar 01, 2021Copper Contributor
Excel crash trying to sort large data file
I have a file that has 30,000 rows, no forumulas in the data just names and addresses. I use conditional formating to highlight duplicates on ID and post code. When i click on data sort to so...
SergeiBaklan
Mar 01, 2021Diamond Contributor
How many conditional formatting rules do you have? It shall be not more than number of formatting variants.