How to Change Pasted Data Format in Macro

Hi there guys, this is a followup to the same spreadsheet used in the following thread:

http://www.excelforum.com/showthread...92#post1933992

When my macro pastes the scores from my one sheet into the other,
it pastes the cells with the same formatting they had on the previous(original) sheet, for ex: the cells are highlighted in red or orange. One color is the color that the cell is filled in with, for aesthetics only, but the other is a conditional format.

Altho this is not a big deal it sort of looks odd/bad.

Is there any way I can add something to the end of the macro so that it wipes out the conditonal formatting or other formatting of items pasted into the Audit Log?

Is it possible to only change the format of those things that are pasted or would it have to change format of everythign in the audit log?

Thanks