Gareth McKee
asked on
Excel: compare items in different worksheets
Hi,
Excel 2016
I have a spread sheet with 4 worksheets.
worksheet1
worksheet2
worksheet3
worksheet4
worksheet4 has a long list of items, most of which are also in either 1,2 or 3.
How can I highlight the items in worksheet4 which do not appear in either 1,2 or 3?
TIA
Gareth
Excel 2016
I have a spread sheet with 4 worksheets.
worksheet1
worksheet2
worksheet3
worksheet4
worksheet4 has a long list of items, most of which are also in either 1,2 or 3.
How can I highlight the items in worksheet4 which do not appear in either 1,2 or 3?
TIA
Gareth
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Roy, I will give this a go.
ASKER
Thanks Roy
Pleased to help
I'll post some instructions if required
Compare-Across-Sheets.xlsx