How to copy a cell's color to other other cell?

[techissue2008]

I have a table with A or B then their cells were highlighted with red and blue color. so, the cell has text 'A' and red color; text 'B' and blue color.

I used a for loop to loop text data from a column and then assign to a string array. However, the text data has background color which I need to get it too.

Please Login or Register  to view this content.

It was assigned before. e.g. 'A' with red color cell

How can I loop through the cells and colorindex array applying the colorindex to each cell individually?

The sheet1's column D and H have various color cells. How can I copy them to another sheet2's particular cell?

I tried to use range, but it copied the colorindex numbers, but not show the color background of the cells.

I posted it on http://www.mrexcel.com/forum/showthread.php?t=325689 yesterday but no reply.

[royUK]

You don't need code to do this, use Conditional Formatting

http://www.excel-it.com/excel_condit...formatting.htm