I have a conditional format in xl2007 that works (fill 9 adjacent cells), but
only if I leave the page and return. This CF is dependent on the value in
another cell, which can change from values 1-4 based on a groupbox radio
button choice. The target cell is formatted as a "number".

There are other CF's in the worksheet that change a cell fill color based on
that cell value, and they respond without leaving the page. I updated the
graphics card driver without any luck.

What do I need to get the CF cells to refresh automatically?

see your other post

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
I have a conditional format in xl2007 that works (fill 9 adjacent cells),
but
only if I leave the page and return. This CF is dependent on the value in
another cell, which can change from values 1-4 based on a groupbox radio
button choice. The target cell is formatted as a "number".

There are other CF's in the worksheet that change a cell fill color based
on
that cell value, and they respond without leaving the page. I updated the
graphics card driver without any luck.

What do I need to get the CF cells to refresh automatically?

this reply does not help anyone but the original poster - would it be possible to clue the rest of us in, so that perhaps we might find the answer as well? Please?

On Tuesday, January 19, 2010 6:24 PM Steve wrote:

I have a conditional format in xl2007 that works (fill 9 adjacent cells), but
only if I leave the page and return. This CF is dependent on the value in
another cell, which can change from values 1-4 based on a groupbox radio
button choice. The target cell is formatted as a "number".

There are other CF's in the worksheet that change a cell fill color based on
that cell value, and they respond without leaving the page. I updated the
graphics card driver without any luck.

What do I need to get the CF cells to refresh automatically?


On Tuesday, January 19, 2010 10:12 PM T. Valko wrote:

see your other post

--
Biff
Microsoft Excel MVP


Submitted via EggHeadCafe
C# Dynamic XElement wrapper
http://www.eggheadcafe.com/tutorials...t-wrapper.aspx

Read the entire thread with possible fix....................found using a google
search BTW

http://groups.google.com/group/micro...+author:valko#


Gord Dibben MS Excel MVP


On Mon, 14 Mar 2011 16:21:36 GMT, glenn horton
wrote:

this reply does not help anyone but the original poster - would it be possible to clue the rest of us in, so that perhaps we might find the answer as well? Please?

On Tuesday, January 19, 2010 6:24 PM Steve wrote:

I have a conditional format in xl2007 that works (fill 9 adjacent cells), but
only if I leave the page and return. This CF is dependent on the value in
another cell, which can change from values 1-4 based on a groupbox radio
button choice. The target cell is formatted as a "number".

There are other CF's in the worksheet that change a cell fill color based on
that cell value, and they respond without leaving the page. I updated the
graphics card driver without any luck.

What do I need to get the CF cells to refresh automatically?


On Tuesday, January 19, 2010 10:12 PM T. Valko wrote:

see your other post

--
Biff
Microsoft Excel MVP


Submitted via EggHeadCafe
C# Dynamic XElement wrapper
http://www.eggheadcafe.com/tutorials...t-wrapper.aspx