View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roadrunnertoo Roadrunnertoo is offline
external usenet poster
 
Posts: 1
Default Excel 2007 Conditional Formatting barely works

1. You can't edit a formula.
2. If you do succeed to edit one of 4 for example. You probably have 6 or 7.
It duplicates at will. If you delete a selected formaula or condition you
have about a 4 in 10 odd that it deleted whatever it wanted to.
3. If you want to change a range value it will change the 1st one you select
but any more say you have an error or just beeps at you. And usually it's
force job end from Task Manager. I had 1 bad day where I had to reboot to
recover now it back to low random. Every time I start it will show 1 to 6
files recovered but it says nothing was fixed.
4. If you copy a cell so you can restore after trying fixes. You will find
that the copy also added duplicate conditional statements.
5. It can't handle Excel 2003 formats you have to have it translate and
start making changes. A program has to be able to handle at least the
previous release and save it to those standards as well.
--
I am local and callable. Just check the support data base.