ShiftFormat.zip (7.6 KB)
I am using SmartMarkers to generate a grid of values. I’m using the (horizontal) parameter. I want to use (Shift) as well, but this causes style issues. (Shift) avoids creating other issues in the template.
If I don’t use Shift, the style from the base cell is copied. It is not copied when using Shift. The (copystyle) parameter has no effect in this case.
In the attached example A4…F8 is the desired output, and A12…F16 is the (shift) output.
I have tried to circumvent this with Conditional Formatting or a Named Range, but both suffer from a similar issue when using (Shift).