Hello everyone,
I have a large binder which I would like to: - That the a formatting of the page is kept,
- Highlight the row and column of a defined area, only in the area defined as D25:CI74
- That the highlight should not be persistent. That is, when I click on another cell, the previous formatting disappears.
- That the formatting color corresponds to the color code hex EE502C with a bold white font
I wrote the following code but it doesn't answer all my needs.
I'm sorry but I can't provide the file because it's confidential.
Thank you for your help.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row > 24 And Target.Row < 75 And Target.Column > 3 And Target.Column < 87 Then
With Target
' Highlight the entire row and column that contain the active cell
.EntireRow.Interior.ColorIndex = 46
.EntireColumn.Interior.ColorIndex = 46
End With
Application.ScreenUpdating = True
End If
End Sub
Bookmarks