high lighting names

L

liljoe

have a business and we use microsoft excel and my question is if i type in one name and there are other names the same is there a way to high light all the rest of the names?
 
J

Jim Gordon MVP

have a business and we use microsoft excel and my question is if i type in one name and there are other names the same is there a way to high light all the rest of the names?

Hi,

Yes. Use the Data Menu.

Data > Filter > Autofilter

Choose a custom filter.

-Jim
 
Top