handysmurf
Board Regular
- Joined
- Jan 17, 2015
- Messages
- 114
- Office Version
- 365
- Platform
- Windows
First let me say that I tried for 3 hours to figure this out myself before posting ... to no avail.
Second, I want to use VBA to do conditional formatting because the conditional formatting panel becomes too cumbersome ... as I make changes or move things around the whole thing becomes cluttered with duplicates working on different ranges and it then takes forever and a day to restore it to the base set of conditions/formatting.
So ... here is what I need to accomplish.... I can manage to duplicate a sub and change colors and names once I have a working code. So I really only need probably 3 different subs? If I can get that accomplished I would like it to refresh/update whenever I save (I save very often so I figured that would be a good trigger) ... so one to call all the subs? I might be able to figure that one out on my own.
Second, I want to use VBA to do conditional formatting because the conditional formatting panel becomes too cumbersome ... as I make changes or move things around the whole thing becomes cluttered with duplicates working on different ranges and it then takes forever and a day to restore it to the base set of conditions/formatting.
So ... here is what I need to accomplish.... I can manage to duplicate a sub and change colors and names once I have a working code. So I really only need probably 3 different subs? If I can get that accomplished I would like it to refresh/update whenever I save (I save very often so I figured that would be a good trigger) ... so one to call all the subs? I might be able to figure that one out on my own.