I have a "template" worksheet, which I copy to other worksheets in VBA
using the Worksheet.Copy method.

The template worksheet has conditional formatting applied to many
cells. When the copy is made, the code then puts values into certain
cells based on a database query.

The strange thing is, the conditional formating does not always kick
in. The formatting just says things like "cell value is less than 1"
set color to red, that kind of thing.

When the copy and populating the data is complete, the value may have
a 1 but also have the color (it's supposed to be normal if it's 1 or
higher).

Is there something I need to do to activate or trigger the conditional
formatting? The formatting works, because if I go to that cell and
change it to 0, then back to 1, the color is fine. It's just not
working when the code copies the template and puts the data in cells.

Any ideas?

Thanks,
Larry

BTW, Excel XP and Windows XP

Hi Larry,

Try:

Tool | Options | Calculation | Automatic


---
Regards,
Norman


"Larry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a "template" worksheet, which I copy to other worksheets in VBA
> using the Worksheet.Copy method.
>
> The template worksheet has conditional formatting applied to many
> cells. When the copy is made, the code then puts values into certain
> cells based on a database query.
>
> The strange thing is, the conditional formating does not always kick
> in. The formatting just says things like "cell value is less than 1"
> set color to red, that kind of thing.
>
> When the copy and populating the data is complete, the value may have
> a 1 but also have the color (it's supposed to be normal if it's 1 or
> higher).
>
> Is there something I need to do to activate or trigger the conditional
> formatting? The formatting works, because if I go to that cell and
> change it to 0, then back to 1, the color is fine. It's just not
> working when the code copies the template and puts the data in cells.
>
> Any ideas?
>
> Thanks,
> Larry
>
> BTW, Excel XP and Windows XP
>

On Jun 4, 3:15 am, "Norman Jones" <normanjo...@whereforartthou.com>
wrote:
> Hi Larry,
>
> Try:
>
> Tool | Options | Calculation | Automatic
>
> ---
> Regards,
> Norman
>
> "Larry" <llj...@netscape.net> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >I have a "template" worksheet, which I copy to other worksheets in VBA
> > using the Worksheet.Copy method.
>
> > The template worksheet has conditional formatting applied to many
> > cells. When the copy is made, the code then puts values into certain
> > cells based on a database query.
>
> > The strange thing is, the conditional formating does not always kick
> > in. The formatting just says things like "cell value is less than 1"
> > set color to red, that kind of thing.
>
> > When the copy and populating the data is complete, the value may have
> > a 1 but also have the color (it's supposed to be normal if it's 1 or
> > higher).
>
Thanks, I have Automatic turned on and that doesn't help.

I also tried hitting the F9 button to cause it to calculate and that
didn't do it either.




> > Is there something I need to do to activate or trigger the conditional
> > formatting? The formatting works, because if I go to that cell and
> > change it to 0, then back to 1, the color is fine. It's just not
> > working when the code copies the template and puts the data in cells.
>
> > Any ideas?
>
> > Thanks,
> > Larry
>
> > BTW, Excel XP and Windows XP- Hide quoted text -
>
> - Show quoted text -