How to Compare 2 worksheets and Highlight New Rows

excel

#1

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!


#2

Use read range to read the excel and “for each row” activity to iterate and analyse the data, do some conditional logic(to get this MONTH data), finally use append range or write range activity.