Tag: Debra Dalgleish

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 …

Macro to fix Duplicate Conditional Formatting rules in Tables Read More »

Tagged with: , , , , ,

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 …

Fix duplicated Conditional Formatting Rules Read More »

Tagged with: , , , ,

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 …

Autocomplete Workaround for Validation Dropdowns Read More »

Tagged with: , , , , ,

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 …

Learning to use Pivot Tables Read More »

Tagged with: , , , ,