Comments | vba_corner: Search Cells and Highlight Found Entries

vba_corner

Search Cells and Highlight Found Entries

Oct 23, 2007 18:00

Imagine you have a long list in your excel sheet and want to find certain entries. Especially if the list gets bigger, it'd be nice to just tell Excel what you're looking for, and have Excel automatically find it. It's faster and more accurately than searching yourself.

( Excel Search - not the ultimate solution )

substring, excel, formulas, search, conditional formatting, wildcards, find

Comments 3

Cant get it to work anonymous October 7 2008, 21:45:23 UTC

Great article and formulas, but when I type in the formula =AND(SEARCH($B$1;A4)>0;$B$1<>""), I get an error everytime that highlights "$B$1" in its first occurence and wont let me run the formula. It says there is a problem with the formula. Why would it work for you and not on my sheet?

Re: Cant get it to work anonymous October 17 2008, 22:06:34 UTC

=AND(SEARCH($B$1,A4)>0;$B$1<>"") works (replace the ; with ,)

Re: Cant get it to work vba_corner November 18 2008, 08:22:17 UTC

Seems like Excel sometimes wants ; and sometimes ,
Usually ; works for me, but one day it didn't, and when I replaced all ; with , it worked again. But after the next start of Excel, it wanted ; again, so I had to change it back. Strange...