Hello, I am trying to use an If Then statement to compare two spreadsheets for content. If the two spreadsheets had the same information, then that row was green. If the one spreadsheet had information that the other one didn't then the row is yellow. Then I would like to summarize all of the yellow data at the bottom of the spreadsheet to know what data I needed to add so that both spreadsheets contained the same data. So far, I have added the CellColor to the Cell Manager but can't figure out the if then statement. Thanks in advance for any help.
Bookmarks