ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the color of the cell marquee when using Ctrl F (https://www.excelbanter.com/excel-discussion-misc-queries/216391-how-do-i-change-color-cell-marquee-when-using-ctrl-f.html)

Mark-Sydney

How do I change the color of the cell marquee when using Ctrl F
 
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?

Max

How do I change the color of the cell marquee when using Ctrl F
 
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
---
"Mark-Sydney" wrote:
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?


Max

How do I change the color of the cell marquee when using Ctrl
 
After installing the sub,
Press Alt+Q to get back to Excel
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

Suleman Peerzade[_2_]

How do I change the color of the cell marquee when using Ctrl F
 
How about autofilters
--
Thanks
Suleman Peerzade


"Mark-Sydney" wrote:

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?



All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com