Hi, i'm trying to do a Dynamic Search and its a little out of my league!
When i type a keyword in the ActiveX text Box, i would like it to highlight every row in C5:G7 using conditional formatting that contains the search term in range J5:T7.
I'm not sure what i've got wrong in the formula in the 'data' worksheet
For example:
If i type 'Nick', row C6:G6 is highlighted amber
If i type 'Alibaba', rows C5:G6 and C7:G7 are highlighted Amber
Bookmarks