Search, find, highlight cell - cells are hyperlinks

[Liverlee]

Hi All

I'm in need of some help - i'm trying to use conditional formatting to highlight individual cell when a word is typed. So if i start to type the word google - the cell containing the word google highlights red with a yellow font.

So if i type g or goo the cell containing the word google is highlighted.

In the past i've used this formula =IF(ISBLANK($G$3), 0,SEARCH($G$3,$B5&$C5&$D5&$E5&$F5)) which works a treat to highlight a row.

but i just want to highlight a single cell rather than an entire row.

My search box is in cell G3

the only cells that contain any text are in
C5,C7,C9,C11, C14, C16, C18, C20
E5,E7,E9,E11, E14, E16, E18, E20
G5,G7,G9,G11, G14, G16, G18, G20
I5,I7,I9,I11, I14, I16, I18,I20.

All these cells are actually hyperlinks, so if you click on C5 it will take you to google, if you click on c7 it will take you to mrexcel, c9 youtube etc etc.

The spreadsheet is just hyperlinks or blank cells.
The spreadsheet goes from cell B4 to J21.

Any advice or guidance gratefully received.

 

[Fluff]

Select B4:J21 and use
=AND($G$3<>"",ISNUMBER(SEARCH($G$3,B4)))

 

[Liverlee]

Blimey that was quick, so simple and works a treat, thank you so much.



i wont tell you how long i've spent trying to figure that out

 

[Fluff]

Glad to help & thanks for the feedback