Forum Discussion

Reid Babbitt's avatar
Reid Babbitt
Copper Contributor
Jul 06, 2018

Conditional Formatting

I don't have a problem using Conditional Formatting, but I do have a problem with the display.

 

I want to color code certain cells. In order to see the results, I have to "refresh" the page, which I do by scrolling one page up or one page down. This looks like an issue with my computer (not enough RAM or video card can't handle the detail) but I've opened this file in other more powerful computers with the same annoying results.

 

It would be nice if Conditional Formatting did its job without having to "page up" or "page down" constantly every time I want to study the data.

 

Could there be a fix for this, or is it just a peculiarity with Conditional Formatting 

excel
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jul 06, 2018

    Hey Reid-

     

    This sounds pretty strange.  Do you have a non-sensitive example file where this is occurring?  I would love to test it out on my PC to see if I can diagnose the issue...or perhaps to tell you whether I see similar behavior on my PC.

    • Reid Babbitt's avatar
      Reid Babbitt
      Copper Contributor
      Jul 06, 2018

      Thanks for your response.

       

      I don't have a non-sensitive example file for you, but I've snipped a "Before Refresh" & "After Refresh" snapshot of the problem.

       

      I have taken this spreadsheet over to another computer that has a top of the line graphics card and is slightly more powerful with better RAM. But the problem persists.

       

      It always "looks" like Excel is struggling to display the page, which is why for years I assumed an upgrade to my computer would solve the issue. If I cursor "Page Up" and return,  the colors then present themselves. I've upgraded both memory and processor with no change in the problem.

       

      I currently have an Intel Core i7-2600CPU@3.40GHz processor with 8GB RAM and running Windows 10 Home ver1803. My Graphics card is GeForce GTX 980.

      • Matt Mickle's avatar
        Matt Mickle
        Bronze Contributor
        Jul 06, 2018

        Hmm that's odd....

         

        Maybe try doing this:

         

         

         

        1. Do this by clicking on the Office button, click on Excel options and in the "Popular" section check the box ""Show developer tab in the Ribbon".
        2. Click on the Developer menu and go to the Visual basic view.
        3. Click on the menu View and select "Properties Window". In that list you can find the "EnableFormatConditionsCalculation"
        4. Set this value to "True" and the auto refresh should work
        5. Perform this action for all worksheets in your workbook.

         

Resources