schroederd1
11-07-2011, 08:28 PM
I'm new to the conditional formatting so this may be really simple but I don't know where to start. I would like to compare columns A & C in workbook1 to A & C in workbook2. Columns A maynot be sorted the same in each workbook. First I think it would have to find the value in A1 of workbook1 in column A of workbook 2. If it finds the match then can it hightlight the value in C1 of workbook 2 if C1 is not a match. Example:
Workbook1 Workbook2
A B C A B C
1 Bob 2 1 Bill 4
2 Bill 4 2 Pat 7
3 Pat 6 3 Bob 2
4 Tim 8 4 Tim 2
In this example it would highlight C2 & C4 in Workbook2 since these values don't match to Pat and Tim's Column C values in Workbook1.
Thanks so much!!!!!
Workbook1 Workbook2
A B C A B C
1 Bob 2 1 Bill 4
2 Bill 4 2 Pat 7
3 Pat 6 3 Bob 2
4 Tim 8 4 Tim 2
In this example it would highlight C2 & C4 in Workbook2 since these values don't match to Pat and Tim's Column C values in Workbook1.
Thanks so much!!!!!