VBA remanent formatting (hightlight row and column) on desired zone

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.

Please Login or Register  to view this content.

Thanks, I'll have a look.