Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change color for 'found' cell (2000/SR-1)

    Is there a way to change the color and/or fill of a 'found' cell?

    I have a huge spreadsheet that I work with on a daily basis and I always have to find something in it. It would help a great deal if the 'found' cell (using the Find command/Ctrl-F) would change in border color and/or the fill to make it easier to differentiate it from the rest of the cells.

    Thanks.
    Pooja

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change color for 'found' cell (2000/SR-1)

    The Find command selects the found cell, so it automatically gets a thick black border.

    It would be possible to create a macro that replaces the built-in Find command and highlights the found cell some other way, but I fear that it would be virtually impossible to determine when this highlighting should be removed, and how to distinguish it from highlighting applied another way.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change color for 'found' cell (2000/SR-1)

    Consider downloading my flexfind utility ffrom the Excel MVP site listed below. It gives you a list of all found cells, which you can click on to select them.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Change color for 'found' cell (2000/SR-1)

    Hi Hans,

    There's a post on the Mr Excel site that uses conditional formatting thru VBA to higlight the slected row & column.
    You can find it at:
    http://www.mrexcel.com/hof001.php

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change color for 'found' cell (2000/SR-1)

    Thank you all. I have the Flexfind addin and the macro. They both work wonders.

    Pooja

Posting Permissions

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