View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
violet violet is offline
external usenet poster
 
Posts: 52
Default interior color of macro

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?