Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting works, is there a better way? James E Middleton Excel Worksheet Functions 7 May 22nd 06 10:29 AM
Conditional formatting.... Excel 2002 Gunjani Excel Worksheet Functions 1 February 13th 06 10:58 AM
Conditional Formatting in Excel BaptistKitty Excel Worksheet Functions 2 February 5th 06 06:33 PM
Conditional formatting of a data series in an Excel Chart? Rowan Excel Discussion (Misc queries) 1 July 29th 05 01:21 PM
Excel conditional formatting error Bob Excel Discussion (Misc queries) 9 May 11th 05 03:17 AM


All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"