Share via

Using the Find button & once found what you are looking for making it a different colour/border outline thickerr

Anonymous
2019-06-28T00:10:53+00:00

When using the Find button, I want to make the cell that I have found a different colour/making the outline of the cell thicker, is there a way of doing it?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 47,981 Reputation points Volunteer Moderator
    2019-06-28T11:19:42+00:00

    This can be done with a combination of Conditional formatting and a small VBA code (Macro)

    Not sure of your expertise so here are detailed instructions so you will not be held up asking for further information to implement.

    • Select entire worksheet. (Click where the row numbers and column Id's meet.)
    • Select "Conditional formatting" (Home ribbon)
    • Select "New Rule"
    • Select "Use a formula to determine which cells to format"
    • Copy the following formula and paste into the field "Format values where this formula is true"

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

    • While still in Conditional formatting, Click Format button.
    • Select the required tab at top of dialog. (I suggest the Fill tab. Thick borders are not supported in Conditional Formatting)
    • After setting the color, click OK and OK until dialog closes.
    • Next Right click the worksheet tab name
    • Select "View Code" (Opens the VBA Editor at the worksheets module)
    • Copy the 3 lines of code below and paste into the VBA editor (don't change the Sub name)

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

        Application.ScreenUpdating = True

    End Sub

    • Close the VBA editor (Red cross very top right of the editor window)
    • Ensure macros are enabled as follows.
    • If Developer ribbon not displaying then right click anywhere in one of the ribbons and select "Customize the ribbon".
    • On the right side of the dialog check the box against "Developer" and click OK.
    • Select Developer ribbon.
    • Select Macro Security (In the Code block at left end of Developer ribbon)
    • The dialog that displays should default to Macros in left column.
    • Select required security option button. (Option to "Disable all macros with notification" should be OK.)
    • Click OK to close the dialog.
    • Now each time you select a cell then it will be highlighted (Including if selected with Find)

    The workbook must be saved as "Macro Enabled".

    0 comments