Destacar resultados da pesquisa no Excel

Question

É possível que o Excel realce os resultados da pesquisa ou o texto específico que você está procurando? Eu realmente aprecio esses recursos como eles são no Firefox e no IntelliJ IDEA.

    

Answer 1

Eu pesquisei sua demanda no Google e descobri que você pode usar uma macro para fazer isso.

Sub FindHighlight()
Dim tempCell As Range, Found As Range, sTxt, FoundRange, Response As Integer
Set Found = Range("A1")
sTxt = InputBox(prompt:="Enter value for search", Title:="VoG's Finder")
If sTxt = "" Then Exit Sub
Set tempCell = Cells.Find(what:=sTxt, After:=Found)
If tempCell Is Nothing Then
MsgBox prompt:="Not found", Title:="VoG's Finder"
Exit Sub
Else
Set Found = tempCell
Set FoundRange = Found
End If
Do
Set tempCell = Cells.FindNext(After:=Found)
If Found.Row >= tempCell.Row And Found.Column >= tempCell.Column Then Exit Do
Set Found = tempCell
Set FoundRange = Application.Union(FoundRange, Found)
Loop
FoundRange.Interior.ColorIndex = 6
Response = MsgBox(prompt:="Clear highlighting", Title:="VoG's Finder", Buttons:=vbOKCancel + vbQuestion)
If Response = vbOK Then FoundRange.Interior.ColorIndex = xlNone
End Sub

When the macro runs it will highlight the found cells and give the option to clear the highlighting. If you want to temporarily keep the highlighting click Cancel. Then, to clear the formatting later on, run the same search and click OK.

Clique aqui para ver a fonte.