Recently I had a complete list in Excel 2003 set up to conditionally format
all the cells within a range if there was a total number of 25 non-blank
cells. All the names within that range would then automatically change to a
red font.
Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to
the changes! However, these names dont automatically turn red anymore until I
go to the next page and back again. What would I have to do to get those
changes to appear immediatly when the list hits 25??
--
Have a great day!

Sincerely,
Cassie

When upgrades are accomplished by the IT team, they do not compensate for
the individual workstation settings, so some of the things that were routine
before the update will have to be reset to be routine after the update. It
could be that your earlier version had Calculate set to automatic, which
would then trigger the conditional format formula as it occurred. Go to
Tools>Options>Calculation and reset your options.



"Cassie" <(E-Mail Removed)> wrote in message
news:E85E3999-52A7-4CB7-AD53-(E-Mail Removed)...
> Recently I had a complete list in Excel 2003 set up to conditionally
> format
> all the cells within a range if there was a total number of 25 non-blank
> cells. All the names within that range would then automatically change to
> a
> red font.
> Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust
> to
> the changes! However, these names dont automatically turn red anymore
> until I
> go to the next page and back again. What would I have to do to get those
> changes to appear immediatly when the list hits 25??
> --
> Have a great day!
>
> Sincerely,
> Cassie

I actually dont have a Tools Tab, (or if i do, I dont know where to find it)
but following those directions to what I do have I found that there is a
Calculation icon in the Formulas menu. However it's already set to automatic
and my formatting is still not taking effect immediately except the 25th
entry. But still thanks! That got me a little closer.
--
Cassie


"JLGWhiz" wrote:

> When upgrades are accomplished by the IT team, they do not compensate for
> the individual workstation settings, so some of the things that were routine
> before the update will have to be reset to be routine after the update. It
> could be that your earlier version had Calculate set to automatic, which
> would then trigger the conditional format formula as it occurred. Go to
> Tools>Options>Calculation and reset your options.
>
>
>
> "Cassie" <(E-Mail Removed)> wrote in message
> news:E85E3999-52A7-4CB7-AD53-(E-Mail Removed)...
> > Recently I had a complete list in Excel 2003 set up to conditionally
> > format
> > all the cells within a range if there was a total number of 25 non-blank
> > cells. All the names within that range would then automatically change to
> > a
> > red font.
> > Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust
> > to
> > the changes! However, these names dont automatically turn red anymore
> > until I
> > go to the next page and back again. What would I have to do to get those
> > changes to appear immediatly when the list hits 25??
> > --
> > Have a great day!
> >
> > Sincerely,
> > Cassie
>
>
> .
>

Is there an "F" key or a shortcut I could use on those pages that may be
effected if I can't set it to automaticaly change?
--
Cassie


"JLGWhiz" wrote:

> When upgrades are accomplished by the IT team, they do not compensate for
> the individual workstation settings, so some of the things that were routine
> before the update will have to be reset to be routine after the update. It
> could be that your earlier version had Calculate set to automatic, which
> would then trigger the conditional format formula as it occurred. Go to
> Tools>Options>Calculation and reset your options.
>
>
>
> "Cassie" <(E-Mail Removed)> wrote in message
> news:E85E3999-52A7-4CB7-AD53-(E-Mail Removed)...
> > Recently I had a complete list in Excel 2003 set up to conditionally
> > format
> > all the cells within a range if there was a total number of 25 non-blank
> > cells. All the names within that range would then automatically change to
> > a
> > red font.
> > Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust
> > to
> > the changes! However, these names dont automatically turn red anymore
> > until I
> > go to the next page and back again. What would I have to do to get those
> > changes to appear immediatly when the list hits 25??
> > --
> > Have a great day!
> >
> > Sincerely,
> > Cassie
>
>
> .
>

I do not have xl2007, so my knowledge of the idiosynchrosies of that version
is limited. You need to get someone who has more knowledge to assist you.
I think that if you make a new posting and include the conditional format
formula that you are using, the file extenstion type of the file (xlxm or
xlxs, etc/) and a brief outline of what you have tried, someone might come
up with a solution for you.


"Cassie" <(E-Mail Removed)> wrote in message
news:9E34F3F7-6061-4729-B3BA-(E-Mail Removed)...
> Is there an "F" key or a shortcut I could use on those pages that may be
> effected if I can't set it to automaticaly change?
> --
> Cassie
>
>
> "JLGWhiz" wrote:
>
>> When upgrades are accomplished by the IT team, they do not compensate for
>> the individual workstation settings, so some of the things that were
>> routine
>> before the update will have to be reset to be routine after the update.
>> It
>> could be that your earlier version had Calculate set to automatic, which
>> would then trigger the conditional format formula as it occurred. Go to
>> Tools>Options>Calculation and reset your options.
>>
>>
>>
>> "Cassie" <(E-Mail Removed)> wrote in message
>> news:E85E3999-52A7-4CB7-AD53-(E-Mail Removed)...
>> > Recently I had a complete list in Excel 2003 set up to conditionally
>> > format
>> > all the cells within a range if there was a total number of 25
>> > non-blank
>> > cells. All the names within that range would then automatically change
>> > to
>> > a
>> > red font.
>> > Now about 3 weeks ago, we upgraded to 2007... I'm still trying to
>> > adjust
>> > to
>> > the changes! However, these names dont automatically turn red anymore
>> > until I
>> > go to the next page and back again. What would I have to do to get
>> > those
>> > changes to appear immediatly when the list hits 25??
>> > --
>> > Have a great day!
>> >
>> > Sincerely,
>> > Cassie
>>
>>
>> .
>>

Cassie did not say if Autocalc was enabled.

In 2007 Office Button>Excel Options>Formulas.

The calc mode is set here.

Note that the first workbook opened sets the calc mode for all subsequently
opened workbooks.

Make sure a workbook set to manula calc mode is not opened first.


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 23:21:20 -0500, "JLGWhiz" <(E-Mail Removed)> wrote:

>I do not have xl2007, so my knowledge of the idiosynchrosies of that version
>is limited. You need to get someone who has more knowledge to assist you.
>I think that if you make a new posting and include the conditional format
>formula that you are using, the file extenstion type of the file (xlxm or
>xlxs, etc/) and a brief outline of what you have tried, someone might come
>up with a solution for you.
>
>
>"Cassie" <(E-Mail Removed)> wrote in message
>news:9E34F3F7-6061-4729-B3BA-(E-Mail Removed)...
>> Is there an "F" key or a shortcut I could use on those pages that may be
>> effected if I can't set it to automaticaly change?
>> --
>> Cassie
>>
>>
>> "JLGWhiz" wrote:
>>
>>> When upgrades are accomplished by the IT team, they do not compensate for
>>> the individual workstation settings, so some of the things that were
>>> routine
>>> before the update will have to be reset to be routine after the update.
>>> It
>>> could be that your earlier version had Calculate set to automatic, which
>>> would then trigger the conditional format formula as it occurred. Go to
>>> Tools>Options>Calculation and reset your options.
>>>
>>>
>>>
>>> "Cassie" <(E-Mail Removed)> wrote in message
>>> news:E85E3999-52A7-4CB7-AD53-(E-Mail Removed)...
>>> > Recently I had a complete list in Excel 2003 set up to conditionally
>>> > format
>>> > all the cells within a range if there was a total number of 25
>>> > non-blank
>>> > cells. All the names within that range would then automatically change
>>> > to
>>> > a
>>> > red font.
>>> > Now about 3 weeks ago, we upgraded to 2007... I'm still trying to
>>> > adjust
>>> > to
>>> > the changes! However, these names dont automatically turn red anymore
>>> > until I
>>> > go to the next page and back again. What would I have to do to get
>>> > those
>>> > changes to appear immediatly when the list hits 25??
>>> > --
>>> > Have a great day!
>>> >
>>> > Sincerely,
>>> > Cassie
>>>
>>>
>>> .
>>>
>

Calculation is set to automatic.
My Conditional formatting is set to formula =$X$32+$W$32>=25 and it
currently only changes the 25th entry right away, once I go to a different
sheet the whole list will then format as needed. But how do I make it change
while still on that page?
--
Cassie


"Gord Dibben" wrote:

> Cassie did not say if Autocalc was enabled.
>
> In 2007 Office Button>Excel Options>Formulas.
>
> The calc mode is set here.
>
> Note that the first workbook opened sets the calc mode for all subsequently
> opened workbooks.
>
> Make sure a workbook set to manula calc mode is not opened first.
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 11 Dec 2009 23:21:20 -0500, "JLGWhiz" <(E-Mail Removed)> wrote:
>
> >I do not have xl2007, so my knowledge of the idiosynchrosies of that version
> >is limited. You need to get someone who has more knowledge to assist you.
> >I think that if you make a new posting and include the conditional format
> >formula that you are using, the file extenstion type of the file (xlxm or
> >xlxs, etc/) and a brief outline of what you have tried, someone might come
> >up with a solution for you.
> >
> >
> >"Cassie" <(E-Mail Removed)> wrote in message
> >news:9E34F3F7-6061-4729-B3BA-(E-Mail Removed)...
> >> Is there an "F" key or a shortcut I could use on those pages that may be
> >> effected if I can't set it to automaticaly change?
> >> --
> >> Cassie
> >>
> >>
> >> "JLGWhiz" wrote:
> >>
> >>> When upgrades are accomplished by the IT team, they do not compensate for
> >>> the individual workstation settings, so some of the things that were
> >>> routine
> >>> before the update will have to be reset to be routine after the update.
> >>> It
> >>> could be that your earlier version had Calculate set to automatic, which
> >>> would then trigger the conditional format formula as it occurred. Go to
> >>> Tools>Options>Calculation and reset your options.
> >>>
> >>>
> >>>
> >>> "Cassie" <(E-Mail Removed)> wrote in message
> >>> news:E85E3999-52A7-4CB7-AD53-(E-Mail Removed)...
> >>> > Recently I had a complete list in Excel 2003 set up to conditionally
> >>> > format
> >>> > all the cells within a range if there was a total number of 25
> >>> > non-blank
> >>> > cells. All the names within that range would then automatically change
> >>> > to
> >>> > a
> >>> > red font.
> >>> > Now about 3 weeks ago, we upgraded to 2007... I'm still trying to
> >>> > adjust
> >>> > to
> >>> > the changes! However, these names dont automatically turn red anymore
> >>> > until I
> >>> > go to the next page and back again. What would I have to do to get
> >>> > those
> >>> > changes to appear immediatly when the list hits 25??
> >>> > --
> >>> > Have a great day!
> >>> >
> >>> > Sincerely,
> >>> > Cassie
> >>>
> >>>
> >>> .
> >>>
> >
>
> .
>

How does =$X$32+$W$32>=25 count non-blank cells in a 25 cell range?

There would seem to be some information missing from your description?

What range of 25 cells are conditonally formatted?

How do the 25 cells get to be blank or non-blank?

What is in W32 and X32?

Might be you have to force a calculation to change the value of W32 and X32.

Do you have activate or de-activate code in the sheet module that controls
calculation?


Gord



On Mon, 14 Dec 2009 07:16:02 -0800, Cassie
<(E-Mail Removed)> wrote:

>Calculation is set to automatic.
>My Conditional formatting is set to formula =$X$32+$W$32>=25 and it
>currently only changes the 25th entry right away, once I go to a different
>sheet the whole list will then format as needed. But how do I make it change
>while still on that page?