Format cell background with HEX color code from another cell

[mediaman]

Hi,

I've got a sheet with values in cells A1 to A841 - these values are hex color codes like #000000; #FFFFFF. On a second sheet I've got a cell range from A1:AC29.

I'm looking for a formula or VBA solution to set the background color of the cells in sheet 2 according to the values in sheet 1. For Sheet 2 / A1:AC1 the first 29 values (sheet 1/A1:A29), for A2:AC2 the second 29 values (sheet 1/A30:A58) and so on should be used. So, basically this gives me 29 rows with 29 columns per row - all in different colors.

Can anyone help. Much appreciated.

Thanks,
mm