View Single Post
  #1   Report Post  
Old August 16th 19, 01:42 AM
Gene Haines Gene Haines is offline
Junior Member
First recorded activity by ExcelBanter: Sep 2006
Posts: 21
Default Conditional Formatting Under Multiple Conditions

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

Last edited by Gene Haines : August 16th 19 at 01:49 AM