I've been trying to create a simple formula that will highlight cells in one row if some text appears in another cell. I've tried all sorts of variations but it simply will not work and yet I have other rules on my spreadsheet that are exactly the same and DO work. I'm at a total loss. I do wonder if the " on my keyboard is perhaps not recognised? But it looks the same on screen. So here is what I'm trying to achieve:

Highlight cells B41 - K41 in orange if cells Z2 or Z3 contain the words shipping label. There could be other text surround 'shipping label' but it's only those two words I'm looking for.

I started by highlighting cells B41-K41 ensuring that B41 is the active cell. I created a new rule with this formula: =SEARCH("*shipping label*",$Z$2:$Z$3). I've also tried various other options just on one cell (B41) such as =SEARCH("*shipping label*",Z2) and even with a MATCH but I cannot get it to work. I also applied the search to the entire spreadsheet in the hope it would find it somewhere but to no avail.

I have that exact formula elsewhere on the spreadsheet for different text and a different colour and it works perfectly every time so I'm stumped!

Please could someone tell me what I'm doing wrong?