Forum Discussion
Conditional Formatting
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.
Hmm that's odd....
Maybe try doing this:
- 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".
- Click on the Developer menu and go to the Visual basic view.
- Click on the menu View and select "Properties Window". In that list you can find the "EnableFormatConditionsCalculation"
- Set this value to "True" and the auto refresh should work
- Perform this action for all worksheets in your workbook.
- Wow...I appreciate your time on this.
"EnableFormatConditionsCalculation" was already set to "True"1. How big is the range you are applying the conditional formatting to?
2. Do you have calculation set to Automatic or Manual? (Formulas tab > Calculation Options)
3. What do your rules look like? How many? What are the Formulas?
I may be able to get the same effect using a worksheet change event....
I can find some old threads referencing a conditional formatting bug but it looks like the support article has been removed (dead link):
https://www.mrexcel.com/forum/redirect-to/?redirect=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F213243
1. How big is the range you are applying the conditional formatting to?
That's interesting...when I choose a column, I select the WHOLE column, so that would be like row =1 to row = infinity (or last row on the spreadsheet). Perhaps that is overwhelming things.
2. Calculation is set to "automatic"
3. See Attachment for a typical rule. Nothing complex. The other columns may differ somewhat, but nothing difficult.
