+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Bug: Borders show on cells formatted to be filled white + no Border

  1. #1
    Registered User
    Join Date
    03-28-2019
    Location
    United States
    MS-Off Ver
    Excel 2010 32bit
    Posts
    2

    Question Conditional Formatting Bug: Borders show on cells formatted to be filled white + no Border

    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)

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Conditional Formatting Bug: Borders show on cells formatted to be filled white + no Bo

    Whatever you posted are not valid URLs. You can post your actual file right here, which is better than images.

    The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-28-2019
    Location
    United States
    MS-Off Ver
    Excel 2010 32bit
    Posts
    2

    Re: Conditional Formatting Bug: Borders show on cells formatted to be filled white + no Bo

    I'll still just post screenshots since the workbooks contains confidential information

    Sheet with conditional Formatting Bug:



    Sheet with appropriate formatting:


    Another example of bug:
    Excel Formatting Error - Additional.PNG
    Last edited by 6StringJazzer; 03-28-2019 at 03:35 PM. Reason: Put borders around images to clarify where the screenshot is

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Conditional Formatting Bug: Borders show on cells formatted to be filled white + no Bo

    There is no way to diagnose this from looking at these images. We would have to have your conditional formatting rules, and a description of what you want them to do. You could attach a file with all data deleted leaving the CF in place.

    It is possible that you have a corruption in your file, or even a bug. I have seen in one case a true Excel bug related to conditional formatting, and it sounds a little like yours, and I never found a way to fix it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting row borders, eliminate Inside Borders within row
    By lizziemac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2018, 11:06 PM
  2. [SOLVED] Conditional Formatting for cells that need to be filled out
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2017, 01:30 PM
  3. [SOLVED] Sum cells formatted by conditional formatting
    By hugowhere in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-14-2016, 11:25 AM
  4. [SOLVED] Macro to select the correct border and fill the cells white. VBA Attached
    By anthony.maddick in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-13-2014, 07:41 PM
  5. [SOLVED] Conditional formatting for percentage formatted cells
    By boomboomblock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2013, 07:46 AM
  6. Replies: 0
    Last Post: 09-11-2012, 07:09 AM
  7. Replies: 2
    Last Post: 06-20-2006, 12:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1