Find each occurrence of a set of numbers in column and highlight the rows that contai
I searched all the posts for something that could help me to get this functionality but I found nothing.
I would like to know if it is possible to search in a column ( see in the attached file N4-N311 ) a specific sequence made up of 3 numbers and when it is found, highlight the three rows ( in the example the first occurrence is represented by rows 32,33 and 34 ) which contain the numbers by selecting them through the row identifier ( as shown when opening the attached file ) and it would be optimal to be able to ask to search for the next occurrence using a button (such as the 'Next' button at the top of the sheet).
Reply With Quote