Use case: I want to apply coloring to several cells in a range, e.g. the cells in a column. Suppose the coloring I want is the cell background color (although the text font color or border color might also be relevant). Now, I have a color palette, or even - I'm just looking at sequence of colors in a row or column of the grid of color options in the chooser dialogs, and I want to apply all of them, in sequence. Maybe it's Yellow, Orange, Gold, Brick, Red, Magenta, Purple, Indigo, Blue, Teal, Green, Lime; or maybe it's Dark Yellow 4 ... Dark Yellow 1, Yellow, Light Yellow 1 ... Light Yellow 4. I want to apply one color in the sequence to one cell in the range. But - I don't have a way to select the range, mark the colors, and say something like "apply in sequence". Instead, I have to apply the colors one by one by one.
... and if I have a 2D range, I would like to be able to color the rows in sequence, or the columns in sequence. But let's start with even just a 1D sequence to make life simpler.