You can add a line at the beginning of your macro to select the range that
includes the two columns and use something like

MyRange.Interior.ColorIndex = xlColorIndexNone

That will reset all of the cells in those columns.

"violet" wrote:

for my macro "changes" it will compare the last 2 column of the excel sheet
and change the interior color if the 2 values are different. however, if i
delete the last column and run the macro again, the previous interior change
will still be there. i wish to reset the interior color of the row that has
been changed when i run the macro again.how can i do that?