Forum Discussion
SHSIMPSO
Jan 21, 2025Copper Contributor
Search for Highlighted Cells
Hello,
I am an occasional Excel user working on a special project where I created an Excel spreadsheet whose data consists of a large number of comments. What I am trying to do is find any cell that contains a specific word, highlight that cell, and then create a new worksheet that contains all of those cells with the word in it. The best way I thought of to do this was to conditionally format the spreadsheet containing the data. So now, every cell that has the magic word in it is highlighted yellow. How do I pull only the highlighted cells into a new spreadhsheet? Thanks in advance.
Let's say your data are in A2:Z50 on a sheet named Sheet 1.
On another sheet:
=LET(v, TOCOL('Sheet 1'!A2:Z50, 1), FILTER(v, ISNUMBER(SEARCH("white", v)), ""))