"

I improved Book4 with a macro to color the cells


Regards
Claus B.

Hi Claus,

Hmmm, I am thinking you may have mistaken what the code needs to do. It looks like it formats the VBA and CF sheets assuming those two sheets already are constructed as you show.

The code needs to take sheet 1 and convert it to the format of VBA and CF and then do the color coding of the Q's.

Where sheet 1 is about 1000 rows by around 100 + columns.

So, first the code has to do a massive reconstruction of sheet 1 to the new configuration and apply the color coding to the Q's.

Howard