tittesMrXl
New Member
- Joined
- Mar 28, 2019
- Messages
- 2
I have a sheet that contains ~40 formatting rules.
For some reason, when I scroll through the sheet or make changes to cells, cells that are filled white with no border -> show their borders.
Sheet with conditional Formatting Bug:
https://imgur.com/O5y4t4g
Sheet with appropriate formatting:
https://imgur.com/SbsxM5a
I notice that when I click the "Calculate Sheet" in the formulas tab, the formatting resets to the appropriate formatting.
I have placed an "Worksheet_SelectionChange" sub routine in the "calculate" the sheet on every click. This makes the borders disappear, but this is just a band-aid to the issue and would like to know how to fix this.
For some reason, when I scroll through the sheet or make changes to cells, cells that are filled white with no border -> show their borders.
Sheet with conditional Formatting Bug:
https://imgur.com/O5y4t4g
Sheet with appropriate formatting:
https://imgur.com/SbsxM5a
I notice that when I click the "Calculate Sheet" in the formulas tab, the formatting resets to the appropriate formatting.
I have placed an "Worksheet_SelectionChange" sub routine in the "calculate" the sheet on every click. This makes the borders disappear, but this is just a band-aid to the issue and would like to know how to fix this.