The following line of code removes any fill color applied to the cells in sheet 2:

Sheet2.Cells.Interior.Color = xlNone

Before:

After:

See also:

• Excel VBA, Cell Fill Color
• Excel VBA, Formatting Cells and Ranges using the Macro Recorder

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com