Formula To Check & Highlight Matches

[rahul_ferns76]

Hello Experts
I have an excel file with two sheets
Sheet1 (Daily Production Report) has data of when a job have been built. There can be multiple entries as sometimes the product can be built over a few days
Sheet2 (Production Schedule) has the number and dates it's supposed to be built

I need the formula to check both sheets and if there are any entries on Sheet 1 that dont match sheet 2
The font colour changes to red

See attached. Please advise if it is possible

Thanks
Rahul

[protonLeah]

Select the Prod Ord column C on Prod Sched. sheet to ProdSched
use conditional format formula on Column B of the report sheet:

Please Login or Register  to view this content.

[rahul_ferns76]

Hi protonLeah
Thanks for replying
I cant get the formula to work???