Contextures Archives | The Excel Factor

Macro to fix Duplicated Conditional Formatting rules in Tables

Conditional Formatting, Home Page Post, Macros, VBA

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 »

Autocomplete Workaround for Validation Dropdowns

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