That works great. Doing this with a formula is perfectly fine. I only need to search one column so I used your first formula. I was not familiar with array formulas. One last thing. If I’m not searching and C2 is empty all of the range cells are highlighted. I’m trying to add an IF statement that would prevent this.
|