I am trying to compare 2 excel files (Monthly cost reports) and I have a repetitive task each month of having to compare the old excel file to the new one to see what costs were added. If there is a new row, I highlight it, then add them all up at the end. Im looking for a way to compare these 2 sheets and just change the fill color to yellow if it is new.
I cant figure out how to make it loop to check each row. Do I need to make a macro in excel to highlight the row? How do i get it to loop to check each row?
Thanks for any help in advanced!