Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlighted
In 2007 anyone know how to make a selected column darker so as to make a found cell using Find & Replace more visable
The shading is so light I can hardly see the highlighted cells |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighted
Hi Phil,
Am Fri, 26 Apr 2013 08:24:33 +0100 schrieb Phil Kirby: In 2007 anyone know how to make a selected column darker so as to make a found cell using Find & Replace more visable The shading is so light I can hardly see the highlighted cells try: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim myRange As Range With ActiveSheet Set myRange = Intersect(Target.EntireColumn, .UsedRange) .UsedRange.Interior.ColorIndex = xlNone myRange.Interior.ColorIndex = 15 End With End Sub Put the code in the code module of the expected sheet Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
Quote:
Although I appreciate a macro on each woksheet would work but that will restrict it There must be a way to default in the display properties somewhere Anyone?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighted
Phil
This used to work in Excel 2007........no sure if it still does. You can add or modify a key in the Registry if you are comforatble hacking in the Regsitry. Best to create a Restore Point before attempting any changes. StartRun regedit.exe HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Options On right-side pane right-click on "Options6" and modifydecimal number from 32 to 16. If you don't have an Options6 you must create it by adding a new DWORD value EditNewDWORD Rename to Options6 and set decimal value to 16 Selected cells on 2007 will be Black Gord On Fri, 26 Apr 2013 08:24:33 +0100, Phil Kirby wrote: In 2007 anyone know how to make a selected column darker so as to make a found cell using Find & Replace more visable The shading is so light I can hardly see the highlighted cells |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighted
Yes, it does still work.
Gord On Fri, 26 Apr 2013 14:26:15 -0700, Gord Dibben wrote: Phil This used to work in Excel 2007........no sure if it still does. You can add or modify a key in the Registry if you are comforatble hacking in the Regsitry. Best to create a Restore Point before attempting any changes. StartRun regedit.exe HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\ Excel\Options On right-side pane right-click on "Options6" and modifydecimal number from 32 to 16. If you don't have an Options6 you must create it by adding a new DWORD value EditNewDWORD Rename to Options6 and set decimal value to 16 Selected cells on 2007 will be Black Gord On Fri, 26 Apr 2013 08:24:33 +0100, Phil Kirby wrote: In 2007 anyone know how to make a selected column darker so as to make a found cell using Find & Replace more visable The shading is so light I can hardly see the highlighted cells |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighted
On Fri, 26 Apr 2013 10:16:16 +0100, Phil Kirby
wrote: Claus Busch;1611412 Wrote: Hi Phil, Am Fri, 26 Apr 2013 08:24:33 +0100 schrieb Phil Kirby: - In 2007 anyone know how to make a selected column darker so as to make a found cell using Find & Replace more visable The shading is so light I can hardly see the highlighted cells- try: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim myRange As Range With ActiveSheet Set myRange = Intersect(Target.EntireColumn, .UsedRange) .UsedRange.Interior.ColorIndex = xlNone myRange.Interior.ColorIndex = 15 End With End Sub Put the code in the code module of the expected sheet Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 Cheers Claus, Although I appreciate a macro on each woksheet would work but that will restrict it There must be a way to default in the display properties somewhere Anyone?? Give it a range name, and when referenced in/with 'select', it will always be the expected "highlighted area". Picking it from the drop down list of named ranges up in the upper left corner of the worksheet takes you there instantly, fully and properly highlighted, with absolute and "high" confidence. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighted
On Fri, 26 Apr 2013 08:24:33 +0100, Phil Kirby
wrote: In 2007 anyone know how to make a selected column darker so as to make a found cell using Find & Replace more visable The shading is so light I can hardly see the highlighted cells Once a "find" action has been selected, and there was no "no match found" message, you can use the cursor key to shift over and back one cell, thereby exposing the cell in which the find nested itself. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtracting the highlighted ones | Excel Worksheet Functions | |||
How to copy a highlighted row | Excel Programming | |||
Highlighted | New Users to Excel | |||
Highlighted Cell | Excel Discussion (Misc queries) | |||
Highlighted Cell | Excel Discussion (Misc queries) |