Category: Conditional Formatting

Macro to fix Duplicate Conditional Formatting rules in Tables

Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated and messy Conditional Formatting.  I tweeked this code just a bit so that all

Tagged with: , , , , ,

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: , , , , , , ,

Fix duplicated Conditional Formatting Rules

If you have ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into, I hope the following post helps you.  Basically this situation arises as you go about day to day coping

Tagged with: , , , ,

Monitoring the Workbook Environment

This post is about monitoring the workbook environment for 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

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