Forum Discussion

SHSIMPSO's avatar
SHSIMPSO
Copper Contributor
Jan 21, 2025

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)), ""))

Resources