search button

[karlux_lip]

Hello guys,

I need help creating a search button.


What I need is to create a search button for locations in a storeroom, that is, when I search for the code of an article, through conditional formatting, the location changes color. Can you help?
Add to the attachment to my excel file to get a head of what I'm talking about.

Thanks.

Botão localização.xlsx

[snb]

Excel itself contains all kinds of search buttons.

[p45cal]

Try clicking the button at cell C2 of the Racks sheet.