I'm still on my list that I want employees to use. I am not good on programming so I found conditional formatting. In Column A I have a list of of keywords i.e. Roofing, Shingle, Gutters, Siding, Sheet Metal in each cell, describing what the vendor does fo us. I would like to search using the value that is input in B1 i.e. Siding. I would like it to highlight each row that it finds the word siding in. Then the user can see all of the vendors that do siding. We have a list of 400-500 vendors and I would like the to open it, type what they are looking for and be able to just go down the list to the highlighted vendors and be able to call them.
Thanks!
Rob
Bookmarks