Compare two worksheets and highlight the one sheet’s difference from the other one

T

Tom Ogilvy

for each cell in Activesheet.usedRange
if cell.Value <> Worksheets("Sheet2").Range(cell.Address) then
cell.Interior.ColorIndex = 3
end if
Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top