Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

April 2009 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • VBA Coding Contest

    I'm passing along some information I think will be interesting to many of the readers of this blog. Test your VBA coding skills and win! MSDN® is sponsoring a coding contest for Office 2007, named OfficePalooza ! This sweepstakes will run two weeks beginning April 20, 2009, and features ten fun Visual Basic of Applications™ (VBA) coding challenges in the form of puzzles and games. Each entrant will earn a chance to win one of hundreds of available prizes, determined by a random drawing at the...
    Filed under:

  • Modifying Conditional Formatting Color Ranges in Excel 2007

    Today’s authors, Amit Velingkar, a Program Manager on the Excel team, and Bob Silverstein, a User Experience Researcher on the Excel team, talk about creating professional looking Color Ranges in Excel. Introduction: My fellow PM on Excel, Robin Wakefield, wrote a blog article on how to create professional looking charts in Excel 2007. Continuing with the same theme, we will investigate the idea of tweaking Color Ranges in Excel 2007. We will start with a default Conditional Formatting Color Range...

  • A Robust Way To Reference Multiple Columns In a Table

    I’m sure many of you have built a spreadsheet like this before: you’ve got a table of data; one of the columns in this table contains a formula which references a span of columns in the same table. The number of columns you need to reference may change over time as requirements change. How do you you build this table in such a way that the number of columns can be changed without breaking the formula that references them? Let’s walk through a somewhat contrived but simple example to demonstrate the...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.