ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Conditional Formatting Under Multiple Conditions (https://www.excelbanter.com/new-users-excel/454401-conditional-formatting-under-multiple-conditions.html)

Gene Haines August 16th 19 01:42 AM

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


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com