VBA Code to search keywords, then highlight when found

I'm certain this has already been asked, looked at some links wasn't getting the code to work

would like to see a macro that i can use to highlight, color font, somehow make visible than all other text when found.

I found this formula which tells me one of my keywords was found, however would like a macro to highlight or color the font of the specific keyword found

=OR(ISNUMBER(SEARCH(" " & $B$3:$B$67 & " ", " " & Y3 & " ")))


currently i have about 60 keywords in 1 column (B) however could be in seperate workbook or i could add a new tab, if one works better, let me know please.

workbooks i have to review have multiple tabs or worksheets, some with larger amounts of data than others. primarily i only need to search for my keywords in 1 column that has the bulk text information and replicate this search in the other tabs that vary on where the description is found.

super appreciate any help with this

Hi,
pls upload sample workbook first...

Thnx

M