+ Reply to Thread
Results 1 to 22 of 22

Highlight Selected Cell When Using FIND

  1. #1
    Registered User
    Join Date
    08-13-2007
    Posts
    68

    Highlight Selected Cell When Using FIND

    Hello, I have a worksheet with lots of data on it, resulting in a very busy layout. I have been using "FIND" to search for various numbers within the spreadsheet, however often times it is hard to see which cell "FIND" selects.

    Is there a way to enable Excel to highlight the selected cell? For example could "Find" turn the cell yellow when it finds a match?

    Thanks in advance for any suggestions

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Don't Know about formatting

    But if you click the find all button it will list the cells that match your criteria.
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Registered User
    Join Date
    08-13-2007
    Posts
    68
    Hi, I was just looking for an option that would make this tool slightly more visual, so that I could move through the sheet quickly by inspection

    Thanks again

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Without code.

    Once the cells are found under "Find all" you can SHIFT + down arrow in the
    "found" dialog box which selects all the found cells on the sheet.

    Format>Cell>Patterns. Pick a color.


    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  5. #5
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    Personally i would create a user form similer to the default find form and then you can code it to seach the whole worksheet and highlight the cells that have been found.

    This can be done fairly simply

  6. #6
    Registered User
    Join Date
    08-13-2007
    Posts
    68
    VBA Noob, Thank You! That is exactly what I was looking for. Are there any options for a macro that would do this automatically?

  7. #7
    Registered User
    Join Date
    08-13-2007
    Posts
    68
    Stuie...that sounds very interesting, but over my head. I have done some programming, would not know where to begin as far as coding the form

  8. #8
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    smlaff01 if you would like i will be more than willing to create a demo file that uses this idea??

    and in regards of colouring in the cells automatically you could write a small macro and assign it a shortcut key like Ctrl+q and that may let you use that while the find form is up.

  9. #9
    Registered User
    Join Date
    08-13-2007
    Posts
    68
    Stuie, I hate to bug you, but if you get a chance a demo file would be wonderful! I would GREATLY appreciate it. Thank you so much for your help!

  10. #10
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    no problem mate, i have already started working on it

  11. #11
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    This code give the user a inputbox

    Please Login or Register  to view this content.
    VBA Noob

  12. #12
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    hi again,

    i have attached a simple example of a custom find form i have made that will mark all cells with an EXACT MATCH in the colour red.

    feel free to alter it or change it.

    i havnt error checked it fully but this should work nicely if you keep it simple lol.

    any questions PM me as its easier

    Please Login or Register  to view this content.
    EDIT:

    you will need to save the demo i think and to show the form press Ctrl+q
    Attached Files Attached Files
    Last edited by VBA Noob; 06-12-2008 at 03:46 PM.

  13. #13
    Registered User
    Join Date
    08-13-2007
    Posts
    68
    Thank both of you all so much! I really really appreciate your help. I've learned so much fromt his board, you guys amaze me.

  14. #14
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    lol no probs smlaff01, one thing i would suggest doing to the demo i posted is away of unmarking the cells when you have finshed with them being marked.

    other than that glad i could help

    EDIT:

    and to set the form ShowModel to false (sorry i forgot) lol

  15. #15
    Registered User
    Join Date
    07-16-2009
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Highlight Selected Cell When Using FIND

    This function is only highlighting the cell....i want to hightlihgt the text...change the text color which is finding

  16. #16
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Highlight Selected Cell When Using FIND

    sajidbagi,

    Please read the forum rues, and then start your own thread.
    Entia non sunt multiplicanda sine necessitate

  17. #17
    Registered User
    Join Date
    10-03-2013
    Location
    lincoln,ne
    MS-Off Ver
    Excel 2003
    Posts
    1

    Thumbs up Re: Highlight Selected Cell When Using FIND

    Thank you for the Find demo.xls‎ file. It works great and that what I was looking for a long time. You're alright!

  18. #18
    Registered User
    Join Date
    09-13-2015
    Location
    Izmir
    MS-Off Ver
    2016
    Posts
    2

    Re: Highlight Selected Cell When Using FIND

    Hi everyone'

    Is there a way to highlight the row of found cell.

    Thank You.

  19. #19
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Highlight Selected Cell When Using FIND

    hanamichi sakuragi,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

  20. #20
    Registered User
    Join Date
    07-14-2015
    Location
    Herndon, VA USA
    MS-Off Ver
    Half Life 3
    Posts
    7

    Highlight Selected Cell When Using FIND

    Hello ....

    I want replace the 1/1/9999 to normal date.

    Scenario:

    On E column : I have 18/03/13like this dates
    On L column : I have 1/1/9999like this dates

    Now I want to replace the cell value in L column which is in present in E column. First it has to search for this format 1/1/9999 in given column and has to replace all these cells by 18/03/13 dates.

    How can I do this?
    Your help will be much appreciated…

    thnk you

  21. #21
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Highlight Selected Cell When Using FIND

    @GEGoodwill,
    See posts #16 & 19:
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  22. #22
    Registered User
    Join Date
    03-10-2016
    Location
    Baltimore, Maryland
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Re: Highlight Selected Cell When Using FIND

    thanks going to check this out

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1