Link to home
Start Free TrialLog in
Avatar of Gareth McKee
Gareth McKeeFlag for Canada

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
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

I would suggest that you use Conditional Formatting with a Named Range and a Formula

User generated image
I'll post some instructions if required
Compare-Across-Sheets.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gareth McKee

ASKER

Thanks Roy, I will give this a go.
Thanks Roy
Pleased to help