conditional formating

Alternatives to Conditional Formatting

Conditional Formatting, Formulas, Spreadsheet Design, Workbook performance

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 »

Monitoring the Workbook Environment

Applications, Conditional Formatting, Formulas, VBA, Workbook performance

This post is about monitoring the workbook environment when working on key workbooks or workbook applications especially if they involve VBA, which is my approach to developing key workbooks for clients. You wouldn’t do this for an ad hoc or quick and dirty workbook. But for workbooks you or your clients are going to be …

Monitoring the Workbook Environment Read More »