Hello,
Rendering a worksheet that has a “Duplicate Values” or “Unique Values” conditional format gets slower with the square of the number of distinct text values in the rule’s range. This happens even when only 20 cell…...rule’s range, as it does for numeric values. Impact Highlighting...distinct text values, whereas numeric values and ranges with fewer...