rwmill9716
Active Member
- Joined
- May 20, 2006
- Messages
- 493
- Office Version
- 2013
- Platform
- Windows
I created a conditional formatting rule that would color a cell gold if it contained an A (B,C,D remain white). When I create it, it works fine, but when I change the dataset (overwrite the old dataset with fresh data), I often lose the rule or it changes on its own. I then have to go back and re-establish the rules for 30 columns. Is there a way to make the conditional formatting rules more permanent?