VBA IF with OR

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" :

Please Login or Register  to view this content.

Thank you very much in advance for your help

Perhaps

Please Login or Register  to view this content.

Thank you very much Jindon ! It is working BUT only if I open my VBA window with in the background the workbook "wk49production"
However my bouton command is on another workbook..I guess It's a problem of "calling" the workbook ?

I have this macro on another workbook. If I press my bouton command it is not working.

However, If I open the Visual Editor, with in the background my workbook "Wk49production", then It is working perfectly.

Can't understand why, as I am mentionning "Set db = Workbooks("wk49production")"

My problem of workbook is solved, I have changed a few brackets :

Please Login or Register  to view this content.

But no "NL" in color ("FR" still fine)

I have tested in the like situation and worked as it should....

Unfortunately no..If I have "NL" in one cell and "6" on the other cell (same row), it won't color

I have just tried to put "NL" in the first postion and it would work fine, but not with "DE" which would be 2nd position.
So there's a problem with my "OR" statement I reckon.

See the attached

Thank you so much Jindon for taking the time to help me. Much appreaciated.

The thing is that I have "NL" and "DE" on workbook Wk49Production, but also the "6" on this same workbook. (so when I have "NL", and 6 on same row = color)

(My macro is stored in another workbook, with my button command)

Do you mean

Please Login or Register  to view this content.

?

Jindon you're the man !

Sorry I should have explained more in details from the start.
A HUGE thank you to all of you for the time you spent helping me.

And thank you again Jindon !