Searchable cell - highlight results as you type your search

Hi

that can be done, please use Use cell conditions in Numbers on Mac - Apple Support

You would have to hit "Enter" for your search text, it will not start searching / highlighting when you only type the text in.

You also have to add the $ for row and column! $B$1

This is also helpful

https://www.youtube.com/watch?v=-4wn6-f4gRg

Regards Ralf

Unfortunately, Numbers doesn’t support conditional formatting based on another cell's value. Therefore, you can't automatically highlight cells based on the search. However, you can make a little modification to your table.

For example, you can add a column after the description column, and name it "Match or not".

Then in C3, type in the formula: =IF(AND(NOT(ISBLANK($B$1)), NOT(ISERROR(SEARCH($B$1, A3)))), "Match", ""). Copy this formula to the rest of the cells in column C.

You can refer to the screenshot below:

Then you can try searching in B1. For example, you can type in 12, and you can see all the matching rows will return Match in column C, like the screenshot below.

Try typing C12, and only one row will return Match.

Hope this can help you!

You can use Command Enter to enter the data without it moving to another cell. Then use Option Return to start typing again. Of course, nothing is just simple like that. If you use Command Return when you didn't type anything, it will move the selection to the parent (i.e., you will select the entire table) and if you use Option Return while typing it will make a line feed in your text.