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