JohnTravolski
New Member
- Joined
- Nov 25, 2015
- Messages
- 45
- Office Version
- 2019
- Platform
- Windows
I want to use an Excel Macro to give a specific part of a row (for example `B1:G1`) the conditional formatting that highlights any duplicate cells in the row as red. In other words, the equivalent of choosing this option with that specific row selected:
It's important that it only applies to cells in that range. If I run the macro again with cells `B2:G2`, the conditional formatting should not consider any values in `B1:G1` (this is the default (and desired) behavior of choosing the option in the picture).
How would I do this with an Excel macro?
It's important that it only applies to cells in that range. If I run the macro again with cells `B2:G2`, the conditional formatting should not consider any values in `B1:G1` (this is the default (and desired) behavior of choosing the option in the picture).
How would I do this with an Excel macro?