Prev: if function
Next: Exel only prints to a file
From: Steve on 19 Jan 2010 18:24
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?
From: T. Valko on 19 Jan 2010 22:12
see your other post

--
Biff
Microsoft Excel MVP


"Steve" <Steve(a)discussions.microsoft.com> wrote in message
news:D9060253-BC50-4CF2-88C3-40F609C619E9(a)microsoft.com...
>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?


 | 
Pages: 1
Prev: if function
Next: Exel only prints to a file