Hi world

I have two workbooks
Workbook 1 contains a list of current order numbers
Workbook 2 contains a list of order numbers on hold

Data is in same column in workbooks

I wish to highlight order numbers on hold in workbook 1 list after comparing to workbook 2 list

Any help will be appreciated.
Thanks