I've seen many videos now on YouTube and other sites explaing how to use the search function in Excel and it just doesn't work with my excel....
I have three coloms in my sheet (A, B & C)
They all have 10 rows with data (A1-10, B1-10, C1-10)
What I want is to type some text in Cell E1 and the typed text will then be searched for in the range A1:C10
If the text is found, the cell is highlighted with a different color.
Apparently this should be very easy to do if I believe all the videos and sites but not with me :-(
Who can help me solve this ???? Don't want to do it with VBA as it should be a build in option with excel....
Bookmarks