you don't need a macro to copy formats. Select cell Say A2. Click on Format painter Icon (paint brush). select the range you wish to paste it to. If this is not what you are looking for, pl explain why colors should change.If the color is from conditional formatting, it won't get copied.
'Sheets("PowerAnalysis").Cells(3, 8).Interior.ColorIndex = Sheets(1).Cells(10, 8).Interior.ColorIndex
Sheets("PowerAnalysis").Cells(24, 11).Interior.ColorIndex = Sheets("Report").Cells(1, 5).Interior.ColorIndex
It didn't work. Do you or anyone else have any ideas?
If your cells are colored by way of conditional formatting; see the FormatConditions Property in VBA help. When you apply conditional formatting, your cell may now have several interior colors. For example, if range A1 has an interior color of blue and conditional formatting applied that shades it as red, you now have at lease two interior colors and you must distinguish between what color you are after.