Conditional formatting performance improvement
Conditional Formatting;s performance needs to be improved on when being used with filters over 20k rows. We opened a Microsoft premier case and this was noted as an issue. Thank you for any improvements you can make to the tool as it's very useful.
Ed Klein commented
Lots of people complaining about this, but Microsoft says they aren't aware of any issue. See https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2016/excel-2016-filter-takes-too-long-to-change/2f18a4d2-75ab-4827-8979-07cc7774eb6b.
The entire time it took me to find that post, read it, come to this page, find this suggestion and post my comments, I have been waiting for Excel to respond to my request to sort by color in a spreadsheet that contains 93k rows and a single column.