How can I have Excel highlight not only the row where the text resides but also highlight the text I am searching for. I have created a conditional rule to do this but I don't know how to transport the rule from spreadsheet to spreadsheet. Instead of creating a rule I would like to just click and select the means of doing this so it can be randomly created easily in any spreadsheet i deal with.
The default current search function does not really highlight the row so it can easily be seen, and if you have borders around your cells it is even harder to discern the search result from the overall page of data. Hope you can help?