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" wrote in message
...
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
ToolsOptionsCalculation and reset your options.



"Cassie" wrote in message
...
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


.