Hi all,
I have a problem. Basically, I have a workbook with multiple worksheets which will have participant information. I'd like to be able to compare and highlight the unique values across two of these worksheets based on the ID value in column A of each worksheet.
For example two of the worksheets should contain information on the same participants, therefore I'd like to know when a participant appears in one worksheet but not the other based on the ID number in column A of each worksheet. I have been playing around with a sample workbook and thought I had achieved this using conditional formatting by using the formula below.
=SUM(COUNTIF(INDIRECT("'Sheet" & ROW($1:$2) & "'!$A:$A"),$A1))<=1
However, I have issues because every 2 weeks I will be copying and inserting new data into one of these worksheets from a different location, and when doing this the formulas stop working.
I'm a relative newbie to excel formula so any help would be appreciated.
Cheers
Bookmarks