A further question.

There is some color formatting on sheet 2 that needs to go to sheet 3 when the code is run.

I suppose it will take something like this...

..PasteSpecial Paste:=xlPasteFormats

but I can't figure where to add it in. Tried a place or two but errors out or won't compile.

So basically want to keep the formatting for whatever was on sheet2 that gets moved to sheet 3.

The Sub ColumnsCompareTwo copies entire sheet 2 to sheet 3 and then eliminates much of it where does not match etc. That seems to me to be an even bigger challenge.

However, I cannot figure how to carry formatting to sheet 3.

I am inquiring as to whether the formatting is conditional formatting or on sheet fill. I suspect that will make a difference in the coding.

Howard