I am using a drop down to allow the end user to select from a series of colors in the drop down that will change the header row color.
The code I have now changes the color as it should but does not change the color for the header when it appears on any pages other than the first instance.
Even when the header is already visible on pages 2 or 3 it still will only change the first instance.
The code I am using now is:
Cell1.border.fill.color.value = "204,255,204";
I have tried changing the cell to a text field with global bindings which returned the same results. I have also tried changing header row only and not including the cell, same results.
Any help is appreciated.