Hello all,

The subject line pretty much describes what I want to do. I've read a ton online and for whatever reason I cant seem to get it to work.

I have a growing excel file with several different users. They all use 12 inch screens that are irreplaceable so i am trying to make a better visual mouse trap here.

They must use the excel file to pull info from based on using a sales order number. They currently Control F and punch in the number which highlights the cell but i think they (older employees wearing glasses) would like it better if it were to highlight the entire row the cell is in so they can have a better visual location assistant. I have tried highlighting the whole gride and doing some conditional formatting but have not had any luck with the correct formula.

Thanks for any and all assistance