Default line thickness

Question

I'm color blind and I have a hard time finding the selected cell when performing a CTRL-F.  It's very hard to see and I believe if I could make the default line width larger or even change the color it would help me.  I know I can use the find all option and read the location of each cell.  Let me know if this is possible.  Thanks

Answer 1

Chip Pearson has created a very handy free Add-in named RowLiner.xla

Will highlight the active cell with your choice of color. . . .does not destroy existing cell formats.

Customizable to your liking and will operate on any active workbook.

Download from here. . . .

http://www.cpearson.com/excel/RowLiner.htm

Gord

Answer 2

You also said "I know I can use the find all option and read the location of each cell".

The ActiveCell address is also displayed in the field to left of the Formula bar. See following screen shot

Answer 3

OssieMac,

Thank you very much for the quick response to my question.  I will try your suggestion and I'm sure it will work, but I was hoping to change some default setting that will automatically work with any excel sheet I open on my system.  Thanks again.

Answer 4

To Tim,

My apologies. I forgot to provide you with all of the information.

After selecting, you need to press F9 to force the worksheet to update and display the format in the ActiveCell.

Alternatively you can use the VBA code below to automatically force the worksheet update after each selection.

1. Open the VBA editor (Alt and F11)
2. In the Project explorer (left column) double click on ThisWorkbook to open the module. You might need to expand the tree by clicking on the plus signs to see ThisWorkbook.
3. Copy the code below and paste into the VBA editor. (Do NOT change the sub name or it will not work)
4. Close the VBA editor (Alt and F11)
5. Save as macro enabled workbook.
6. Ensure macros are enabled. See Help for how to do this. The option to "Disable all macros with notification" should be OK.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

    Application.ScreenUpdating = True

End Sub

Answer 5

Hi Tim,

You can apply conditional formatting to the entire sheet so that the selected cell is formatted to your choice.

1. Select Home ribbon
2. Select entire worksheet (click the little square top left of sheet where the column Id's and row numbers meet.)
3. Select Conditional formatting
4. Select New rule
5. Select "Use a formula to determine which cells to format"
6. Copy the following formula and paste in the field under "Enter values where this formula is true"

        =AND(CELL("row")=ROW(),CELL("col")=COLUMN())

Click the Format button and select the type of formatting required. Note that there are tabs at the top where you can select Font, Border or Fill (You can  ignore Number format tab because I don't think that will do anything for you.)

Now every time you select a cell or range, the formatting will be applied to the ActiveCell. (Note that I have said the ActiveCell. The ActiveCell is the first cell of a selection (the one that remains the light color with the remainder of the selection shadowed.)

Note that it will always apply to the ActiveCell and not just with Find.

Hope this helps.