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. 

Tagged with: , , , , , , ,

My Custom Ribbon using Formulas to Create XML code

I recently finished a pet project of creating a custom ribbon in XML driven by an Add-In to access my personal macros.   These are the ones you collect over the years and use in your day to day work  to

Tagged with: , , , , , , , , ,

Check range for specific characters

If you are working with output from other systems (or preparing input for other systems) you might need to find certain characters that cause problems.  In my case I was creating XML code for a custom ribbon from Excel formulas

Tagged with: , , , , ,

Avoiding 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

Tagged with: , , ,