Tag: Debra Dalgleish

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

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

Autocomplete Workaround for Validation Dropdowns

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown

Tagged with: , , , , ,

Learning to use Pivot Tables

This is general post for anyone out there not using Pivot Tables.  You need to!  I am also going to do a similar post shortly for anyone not using Tables as well.  I think both tools are just so very

Tagged with: , , , ,
Top