That is not always possible.
The 7 days have different opening hours which trigger a certain Data Validation allowing to slot in certain tasks during / outside of trading hours.
Because there are different stores with different trading hours I am running a macro to create the different versions which requires to copy and paste certain areas with Data Validation. This works fine for the DV however everytime I copy and paste an area with conditional formatting it creates another rule on top of the already existing rule.
I thought about clearing the conditional formatting as the first step of my macro and then applying it as the final step but was hoping someone would have another suggestion.
Bookmarks