SmartArt

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Office 2007 and 2010 Sundry Tips and Hints

There is just so much going on with the whole change over from Office 2007 to 2010, and for those of you still stuck in 2003, even more important for you to start convincing your organisations of the need to go straight to 2010.

We have been running the beta 2010 here solidly an all our main machines here for 2 months now, with some individual test machines previous to that. Unfortunately now we have to have test and development environments in both 2003 and 2007 so that has doubled our required number of Virtual Machines.

Following are some of the latest news and bits and pieces as well as some other MS Office related information I have come across recently.

Excel 2007 and 2010

Excel Conditional formatting. Conditional formatting in 2007 is one of the main reasons people come to Spyjournal.biz. These two articles are the single most hit articles of the thousands here with over 50,000 views between them:

Amit Velingkar has written conditional formatting rules simplified while Dick Kusleika has written some code to list out all the conditional formatting rules in a worksheet