• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search box with conditional formatting partial matches highlight cell

SjoerdG

New Member
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 :)
 

SjoerdG

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

SjoerdG

New Member
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

Excel Ninja
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?
 
Top