Note this only works for Tables. One day I will adapt this code for a 2nd macro to work with a specified range. 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 Conditional Formatting rules. I tweeked this […]
Macro to fix Duplicated Conditional Formatting rules in Tables Read More »
Have you ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into? This is what I mean by the term, duplicated Conditional Formatting Rules. I hope the following post helps you. Basically this situation arises as you go about day to day coping and pasting into a
Fix duplicated Conditional Formatting Rules Read More »
As might know there is no autocomplete functionality or any other features such as different font sizes with good old Data Validation cell dropdowns. On a client’s project I worked on today we really needed autocomplete capability. The dropdown list was 80 rows long and the values were messy to scroll through some with 3
Autocomplete Workaround for Validation Dropdowns Read More »
This is a general post for anyone out there not using Pivot Tables. Do yourself a favor, 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 powerful and if you want to be an advanced user
Learning to use Pivot Tables Read More »