Excel has a limit of the number of conditional formatting rules a sheet can handle before it locks up and prevents any more from being added. This can become an issue in complex sheets where one or more users or VBA scripts does a lot of copying and pasting and unintentionally duplicate rules.
When you use 'Manage Rule..." in Excel, it gives you a tiny box showing the list of all rules present on the sheet (assuming you select 'This Worksheet' as your scope). But this doesn't help me determine whether a sheet has fifty rules or a thousand rules, and doesn't help quantify the risk associated with that sheet's current condition.
Therefore: How can I determine the number of Conditional Formatting Rules present on an Excel spreadsheet?
Related: Is there an easy way to manage a large number of conditional formatting rules?