Unable to delete rows using VBA

Hi.

I was looking for some assistance please, I have spent the best part of today trying to find a way to do this but really struggling

Whilst browsing online I found a few examples but when I tried using these none of them have worked for me

I have a workbook with several worksheets, on each worksheet I need to delete all rows that meet the following criteria

1, All cells in columns B that are blank, and
2, All cells in column B that contain text "Blue" or "Black"

As far as deleting all rows that are blank I have this working using the following coding

Please Login or Register  to view this content.

But i am not sure why the following does not work? it does remove all the blank rows but doesnt delete the rows where column b contains blue or black

Please Login or Register  to view this content.

Any help is appreciated, thanks

Use xlor instead of or