Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 2,897
- Office Version
- 365
- Platform
- Windows
When a user copies cells that have Conditional Formatting (CF), sometimes a new CF rule gets added with the same formatting as the previous rule. Let's say I have CF on a wide area A3:T400. I copy a row and paste below. I now have a new rule that covers only the new pasted row along with the original CF for the entire area.
Is there any way to prevent CF replication?
Is there any way to make the CF range dynamic?
Is there any way to prevent CF replication?
Is there any way to make the CF range dynamic?