I have a fairly large spreadsheet, about 500 columns, by over 2000 rows.
I want to make the spreadsheet use less resources of the PC, open faster...
Which is better: 1. conditional formatting rules that apply to the whole area
or 2. the same rule 20 times where each time it only applies to...