How do I change the color of the cell marquee when using Ctrl F

M

Mark-Sydney

When using "Ctrl F" to find a cell the result is shown by a marquee around
"found"cell. This marquee is very difficult to see in a large table with
borders. How can I change the colour or line thickness of the marquee used by
excel to highlight the cell?
 
M

Max

As a close fit, you could try this sheet sub below, which will color the
selected cell(s) light blue. Do note that the "undo" functionality for the
sheet will be disabled.

To install the sub, right-click on the sheet tab > View Code
Copy n paste it into the code window (whitespace on the right)

'-------
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 8
End Sub
'-------

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
how to get address of source of copy (range with marquee a.k.a. "marching ants") 0
Change Color of cell 3
Making "Change Highlighting" feature darker 1
how to get the content in bigger font and in color when points 0
Change text color with an IF statement 5
change the rows value based on conditions 0
How do I change the color of the cell pointer? 7

Top