Highlight the searched cell in Find

[naveenmarapaka]

Hi,

How could I highlight the searched cell in Find search as it would be easy to identify.




regards

[etaf]

what is your find criteria

you could use the same formula in a conditional format

a sample spreadsheet would help

[naveenmarapaka]

Normal, the way how will find through Ctrl +F and typing the word and Enter.


I want the result cell should be highlighted with a color.

[etaf]

OK , Not sure how best to do that with a find , i thought you had a cells using =FIND()

[naveenmarapaka]

So there is no solution for it ?

[AB33]

This code will highlight the searched item cell in red

Please Login or Register  to view this content.

[naveenmarapaka]

Hi,
Here we need to enter entire text of the cell then only its working
like Cell Text is "whole world" and we have to enter full text "whole world" in order to get result

May be because of LookAt: Xlwhole used in code.

but can we get it even if some part text is matching in the cell , like Cell Text is "Whole World" and we are search for "world"

[AB33]

If you want partial match, change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

[naveenmarapaka]

yes its working and getting result with all matched cells with VBRed,
but can it get code with real time find result,
like let's say I am searching for word "Whole" and we have ended up with 5 cells having this word.

with above code all 5 cells are getting red, but I want with find next option and the activated matched cell only should show
colored.

[apo]

Heres something similar...

Press CTRL + s to open the custom search dialogue..

Please Login or Register  to view this content.

[naveenmarapaka]

This is wonderful, it really worked perfect the way i wanted !! thanks a million Apo.

[apo]

No worries.. glad it helped..