Conditional Formatting Does Not Refresh Automatically

[Steve]

I have a conditional format (fill on a range of 9 cells) that only works when
I leave the page and return again. It works as intended with this manual
kick, so to speak, but can I set something to make this work without the
kludge? I updated the graphics driver. Any help would be appreciated!

[T. Valko]

I've experienced this a couple of times in the past. Not recently, though.

Here's a reply I got from Dave Peterson:

"Dave Peterson"
> There's an acceleration setting under:
> control panel|Display|Settings Tab|Advanced button|troubleshoot tab
>
> Maybe you could try a few adjustments.
>
>
> "T. Valko" wrote:
>>
>> I have a similar problem but in reverse order. The problem is my video
>> card
>> isn't up to the task!
>>
>> Sometimes when I apply formatting it doesn't display properly. When I
>> scroll
>> out of that area and then scroll back the formatting displays properly.
>> It
>> has something to do with the refresh rate of the video. Specing out the
>> video wasn't a big priority when I bought this machine. Now I know
>> better.
>>
>> Biff

--
Biff
Microsoft Excel MVP

"Steve" <St...@discussions.microsoft.com> wrote in message
news:08EBA24C-17B8-40CF...@microsoft.com...

[Steve]

Biff,
Sorry about the double post, I lost the first one and it still does not come
up in a "Conditional Formatting" search. Had to find it from "recent posts by
author". Back to the issue...

I tried high, medium, and low settings on the video accelerator, which did
not work. Might the refresh problem be from using form buttons, Format
Control Cell Link, to change the condition? If so, is there a workaround?

"T. Valko" wrote:

> .
>

[T. Valko]

Sorry, I don't have any other suggestions.

--
Biff
Microsoft Excel MVP

"Steve" <St...@discussions.microsoft.com> wrote in message

news:CB33E33E-5366-4978...@microsoft.com...