Excel formula to find and goto cell
<p>I have a formula that's part of a conditional formatting rule that highlights in green any cell that contains whatever text I type. It works great but I have to scroll to find the row. Is there a way to have the formula goto that cell so I don't have to scroll down.</p>

<p>This is the formula: <code>=SEARCH(input,$B2&amp;$C2&amp;$D2&amp;$E2)</code></p>