I want to create a formula that matches certain characters typed by a users input.
If Brian is typed in a cell, I want it to search a range and highlight those names that start with Brian. Even if there are more characters after Brian.
Any help would be appreciated.
Bookmarks