TedX
Board Regular
- Joined
- Apr 18, 2021
- Messages
- 122
- Office Version
- 365
- Platform
- Windows
The image below shows that I have a conditional format on cell AC4, unfortunately when I run my macros at the end of every day and set up for the next day, that cell creates a second identical format. I just keep going there and deleting it manually, but I was wondering if I could just use an 'If' statement to see if there was already some conditional formatting there, then just leave it and not create a duplicate. Any ideas on how to structure the If statement, or even some other workaround like, clearing out the original and then just letting the rest of the code do it;s thing as there wouldn't be any duplication then, if the original formatting was deleted first.