Hi everyone !
I can't understand why my 2nd condition with "OR" is not taking into account.
That is to say, that it puts in color "FR" but not "NL" :
Sub Generic6()
Dim db As Workbook
Set db = Workbooks("wk49production") 'Worksheets("Packing Production Schedule")
For x = 1 To 1000
Celltxt = db.Worksheets("Packing Production Schedule").Cells(x, 12).Text
If InStr(1, Celltxt, "FR") Or InStr(1, Celltxt, "NL") And Cells(x, 10) = 6 Then
db.Worksheets("Packing Production Schedule").Cells(x, 12).Interior.Color = RGB(0, 255, 0)
db.Worksheets("Packing Production Schedule").Cells(x, 12).Font.Bold = True
End If
Next
End Sub
Thank you very much in advance for your help
Bookmarks