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.
(Cannot post links since I'm new here, but there's no way to explain this without examples)
Sheet with conditional Formatting Bug:
imgur url: /a/O5y4t4g
Sheet with appropriate formatting:
imgur url: /a/SbsxM5a
Another example of bug:
imgur url: /a/BfRyyHO
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 to "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.
(x-posted on Mr. Excel Forums)
Bookmarks