TedX
Board Regular
- Joined
- Apr 18, 2021
- Messages
- 122
- Office Version
- 365
- Platform
- Windows
Hello Humans,
Due to the fact that I am a very poor programmer, in fact, it's really the design aspect that I suck at. I built the program and then did a thousand changes to it, always building onto the original and the whole thing works but there are a few niggling bit's I'd like to fix. As you can see, I have a duplicate rule and if left unattended, this would grow at the rate of one a day. That's bad news for me because I use the program 7 days a week. Currently, I'm selecting cell AC4 and manually deleting one of the rules via Conditional Formatting. Because of the way I created it all, I can't go back and redo the part, which is all copied and adjusted and positioned nightly. Is there any way I can automate (macro) deleting one of the identical rules? I don't care if it's sneaky and I use a helper you can't see I'll try any weird suggestion
Due to the fact that I am a very poor programmer, in fact, it's really the design aspect that I suck at. I built the program and then did a thousand changes to it, always building onto the original and the whole thing works but there are a few niggling bit's I'd like to fix. As you can see, I have a duplicate rule and if left unattended, this would grow at the rate of one a day. That's bad news for me because I use the program 7 days a week. Currently, I'm selecting cell AC4 and manually deleting one of the rules via Conditional Formatting. Because of the way I created it all, I can't go back and redo the part, which is all copied and adjusted and positioned nightly. Is there any way I can automate (macro) deleting one of the identical rules? I don't care if it's sneaky and I use a helper you can't see I'll try any weird suggestion