Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Posts
    99
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Search cell color

    Currently Excel (2007) gives some sort of faded color when it finds a result from searching. To say the least, it is almost impossible to find the search result. Is there a way to make the search cell stand out, preferably by giving it a desired color?

    (Incidentally, searching the forum under the terms "search" and "color" does not find anything useful.)
    [I have been here for years; I had to get things restarted]

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I'm not sure what you are referring to. Excel simply selects the cell with the found value.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Feb 2008
    Posts
    99
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Sorry to be obtuse. Yes, Search does select the cell with the found value. However, the "highlighting" (to coin a term) is not much different from the rest of the spreadsheet. And, in my case, I have the spreadsheet zoomed to 85% or even smaller. This makes finding the selected cell difficult to see. So, I was looking for a way to tell Excel to make the found cell more obvious.

    Interestingly, if I choose "Find All" and scroll through these choices, the selected cells are highlighted with the standard heavy border, just as when working normally. But if I simply choose "Find Next", it is almost impossible to distinguish the choice from the rest of the background.
    [I have been here for years; I had to get things restarted]

  4. #4
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Manchester, United Kingdom
    Posts
    116
    Thanks
    8
    Thanked 17 Times in 16 Posts
    First, when you say "Search", do you really mean "Find"? Am I missing something? If what you are doing is "Find" than you are not getting a standard heavy border for the selected cell when you use "Find Next", instead you get a slight highlight, but you DO get the heavy border if you select from the "Find All" list.

    That is pretty weird behaviour so something else is happening. Do you have any macros on that sheet? Any add-ins? (like maybe a custom search add-in). Do you get the same behaviour with a brand new workbook? As rory says, Find should just put a heavy border round the found cell, nothing else, no colours, no problems with 85% or other zoom.

  5. #5
    Lounger
    Join Date
    Jan 2008
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't know if this will help but I had the same need a few years back with a giant spreadsheet I worked with daily. The below macro worked for me at that time but this was in Excel 2003. It highlighs the entire row/column to the active cell. For example, if the active cell is L10, row 10, column L will be highlighted and meet at L10. In the workbook I had it saved in, I had it pasted into the Sheet in the VB Editor.

    Option Explicit

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Dim RngRow As Range
    Dim RngCol As Range
    Dim RngFinal As Range
    Dim Row As Long
    Dim Col As Long

    Cells.Interior.ColorIndex = xlNone

    Row = Target.Row
    Col = Target.Column

    Set RngRow = Range("A" & Row, Target)
    Set RngCol = Range(Cells(1, Col), Target)
    Set RngFinal = Union(RngRow, RngCol)

    RngFinal.Interior.ColorIndex = 6

    End Sub

Posting Permissions

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