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 hi