I posted this question on another forum, with no success...

I need to copy only the fill color of certain cells to other ranges, not the number formats, borders, alignment, etc. The cells to which I want to copy the background colors might be single rows or columns or several rows by columns in size, so I would prefer to highlight the cells to be colored, rather than all the rows/columns etc.

If the "standard" Excel palette colors were used it would have been simple, but that's not the case.

Trust I've not over-complicated my question!

Thanks in advance!