Hi there,
I have a list of colors (a list of texts, e.g: #ff00ff, #000000… etc), that is 5 entries long.
I then have a repeating group (RG) which can be an infinite length. I want each cell of the RG to sequentially assign its color from the list of colors as follows:
Cell #, List entry #
Cell 1, List entry 2
Cell 2, List entry 3
Cell 3, List entry 4
Cell 4, List entry 5
Cell 5, List entry 1
Cell 6, List entry 2
Cell 7, List entry 3
Cell 8, List entry 4
Cell 9, List entry 5
Cell 10, List entry 1
(etc)
I am trying to think of a simple mathematical operation that allows me to achieve this but really struggling - does anyone have an idea how to solve this?
Thanks