This may work Right-click on your sheet's tab and View Code. Paste in the following: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Borders(xlInsideVertical).LineStyle = xlNone Cells.Borders(xlInsideHorizontal).LineStyle = xlNone ActiveCell.BorderAround ColorIndex:=3, Weight:=xlThick End Sub (found on another site)
Tanya, thanks for replying to me. I'm not sure where this is to be pasted. A little further help would be greatly appreciated. I use the FIND tool in Excel nearly all day at work. It can drive you nuts finding where it "lit".