I have a customer list (!Sheet2 B1 : B100) and I have a result list with
maintenance information and customers names (!Sheet1 B2 :B2000)

The rows and columns on the result list change so the customer name is not
always in the same cell.

I am hoping I can use conditional formatting to say if any customer name
from !Sheet2 B1 : B100 = any customer name in !Sheet1 B1 : B2000 then fill in
cell color and make bold of customer names !Sheet1 B1 : B2000.

Any suggestions?

Thanks in advance
--
Nelson