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