How can I use conditional formatting to catch the error in Job Order 99801256 that has dept Cut and it should be Mold.I would need to use a wild card such as 9980*


Job Order Department
66105648 Cut
66102548 Cut
66102356 Cut
99805678 Mold
99806547 Mold
99806598 Mold
99801256 Cut
34565897 Trim
34569874 Trim
34568796 Trim
34568742 Trim