CHOOSE

Alternatives to Conditional Formatting

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance.  I also mentioned you can use alternatives in these situations and just thought I would […]

Alternatives to Conditional Formatting Read More »

Avoiding Nested IFs

Nested IFs.  We have all done them but there comes a time to find a better way.  In Excel 2003 you were limited to 7 levels of nesting but 2007 onwards the level could be increased to 64.  Both these levels are beyond my pain barrier for an overly complex formula fraught with danger. Even

Avoiding Nested IFs Read More »