Search box with conditional formatting partial matches highlight cell

[SjoerdG]

Hi Everyone,

This is probably a simple question for most, but I'm absolutely stuck.

I have a qualitative data set where I need to quickly see all the cells (not rows) highlighted that contain certain terms.

I can create a searchbox with exact matches with "=A4=$B$1", but I can't seem to make it do a partial match.

Does anyone have any ideas?

Thanks

 

[KenU]

Try

=ISNUMBER(SEARCH(A4,$B$1))

Hope that helps.

Regards,
Ken

 

[SjoerdG]

Hi Ken, Thanks for your quick reply. Unfortunately, this just gives me an error. Any other ideas perhaps?

 

[KenU]

I'm afraid I reversed the order. Try the revision below>

=ISNUMBER(SEARCH($B$1,A4))

 

[SjoerdG]

Hi Ken, thanks again for the quick response. Unfortunately, it's still giving me an error. Due to the nature of the research, I can't share the file. But, does the 'ISNUMBER' also relate to words?

 

[vletm]

SjoerdG
The formula ISNUMBER("19"), "19" is not converted from a text value to a number value, and the ISNUMBER function returns FALSE.

Cannot You even share a sample Excel-file?

 

[SjoerdG]

Hi Vletm, I think I might be able to share a sample file, which excludes most of the data. Hope it helps! Thanks for thinking along.

 

[KenU]

Please see attached.

 

[SjoerdG]

Thank you Ken! You are a genious.