Dynamically highlight any cell that matches what you enter - Excel Tips and Tricks

Discover how to create a search tool that dynamically highlights any cell that matches what you enter. Or highlight row if cell contains partial text,
Also how to highlight find results in excel,and excel find highlight color

Here are the steps outlined in this video.

Enable Developer Ribbon
1) Right-click anywhere in the ribbon
2) Customized the Ribbon...
3) Check on Developer
4) OK

Add Textbox
1) Developer ~ Control ~ Insert ~ Textbox
(under ActiveX Controls)
2) Place text box
3) Right-click on textbox, Properties
4) Set LinkedCell to E1.
5) Close Properties popup.
6) Developer ~ Control ~ Design Mode (disable)

Highlight Rows
1) Select dataset (without header)
2) Home ~ Style ~ Conditional Formatting
3) New Rule...
4) Use a formula to determine which cells to format
5) =AND(SEARCH($E$1,A5),$E$1"")
6) Format
7) Fill tab
8) Select colour you like.
9) OK
10) OK

How to highlight row cell contains partial text - Excel Tips and Tricks
https://youtube.com/shorts/Dhnql3941F0?feature=shares

Sort Excel table by highlighted rows | Filter by highlighted rows in Excel - Excel Tips and Tricks
https://youtube.com/shorts/gPa6_qqJzew?feature=shares

Dynamically Highlight Rows Based On Specific Text In Excel - Excel Tips and Tricks
https://youtube.com/shorts/2eOt7x7XZE0?feature=shares


Dynamically highlight any cell that matches what you enter,excel highlight row if cell contains partial text,how to highlight find results in excel,excel find highlight color,
how to highlight cells in excel based on value of another cell,excel conditional formatting based on another cell dynamic,highlight row if cell contains any text,excel find and highlight row,excel conditional formatting if cell contains multiple specific text,