Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Conditional Formatting   (RSS)
Wednesday, November 28, 2007 1:46 PM

Tracking Split Costs

Today’s Author: Joe Chirilov , a program manager on the who has done a lot of work on both the Excel and Excel Services teams. Joe is going to discuss a spreadsheet he recently built using Excel 2007. Recently a large group of friends and I went on a
Posted by David Gainer | 12 Comments
Monday, October 01, 2007 9:01 AM

Data Bars – Feedback Please

Today’s author: Scott Ruble, the program manager who leads the charting and visualization efforts in Excel. Scott is looking for some feedback on potential changes to data bar behaviour. Excel 2007 has a conditional formatting feature that graphically
Posted by David Gainer | 37 Comments
Thursday, August 17, 2006 5:07 PM

Feedback Please - Conditional Formatting For Right-To-Left Sheets

We are interested in getting some user feedback on how conditional formatting (Data Bars specifically – see here for some info on Data Bars) should behave when the sheet direction is set to right-to-left (RTL). (Background for those not familiar with
Posted by David Gainer | 12 Comments
Monday, August 14, 2006 10:30 AM

Conditional Formatting Compatibility

Today we have the third guest post from Eric Patterson, Excel Program Manager. Eric is writing about compatibility in Excel 2007. Conditional Formatting is one of the areas where we have made a lot of improvements in for Excel 2007. Dave has already described
Posted by David Gainer | 5 Comments
Wednesday, July 19, 2006 6:06 AM

Fun With Conditional Formatting

Yesterday I wrote about some work I was doing with Tables recently. Today I want to do the same for conditional formatting – specifically, using colour scales. (For a refresher, or for those that are new to this blog, you can read up on changes to conditional
Posted by David Gainer | 26 Comments
Thursday, May 11, 2006 10:00 PM

A bit more on Icon Sets – answers to Biff’s and Harlan’s questions

Since a few of the comments that were made on the last post were more easily answered with pictures, I thought I would just go ahead and make a new post out of it. (I have answered the other comments in the comments section of the previous post.) Biff
Posted by David Gainer | 13 Comments
Tuesday, May 09, 2006 9:52 PM

Conditional Formatting Trick 2 – How to get an icon in some cells, but not all cells

A few months ago, I described the new features we have added to Excel 2007 in the area of conditional formatting. One of the new formats we added is called a “icon set” … check out this earlier post for a refresher, but the basic idea is that Excel draws
Posted by David Gainer | 11 Comments
Friday, February 24, 2006 1:32 PM

Conditional Formatting Trick 1 – Multi-Coloured Data Bars

A few months ago, I described the new features we have added to Excel 2007 in the area of conditional formatting. One of the new formats we added is called a “data bar” … check out this earlier post for a refresher , but the basic idea is that Excel draws
Posted by David Gainer | 17 Comments
Wednesday, December 21, 2005 9:57 PM

PivotTable VII: – Conditional formatting gets even better, or visualizing your data in PivotTables

In a series of previous articles I introduced the new conditional formatting capabilities in Excel 12 (see here for the whole series of posts). Today I want to add one more article to the series, which is the work we have done to make conditional formatting
Posted by David Gainer | 8 Comments
Friday, October 14, 2005 1:42 PM

Conditional formatting using VBA - some examples

Since I have had some comments and emails asking about how the new conditional formatting features could be accessed using VBA, I wanted to provide a few brief examples. One of the Excel team’s principles is that when we add new features, we make sure
Posted by David Gainer | 13 Comments
Thursday, October 13, 2005 12:04 AM

More about conditional formatting ...

Another goal that we had for conditional formatting was to address top customer requests, like more than three conditions, the ability to reorder conditions, and the ability to have more than one condition resolve true. Let’s take a look at some of the
Posted by David Gainer | 14 Comments
Wednesday, October 12, 2005 9:48 PM

Conditional formatting meets the ribbon

Now that I have reviewed much of the new conditional formatting functionality we have added in Excel 12, let’s review how we have made it easier to find and use these features. O ne of our objectives was to showcase the feature in a more prominent place
Posted by David Gainer | 14 Comments
Tuesday, October 11, 2005 11:11 AM

New conditional formatting "rules" ...

A few posts back when I summarized our goals for conditional formatting, I said that one of our goals was to make a greater number of scenarios possible without needing to write formulas. Let me briefly explain what I mean. Excel 2003 gives users two
Posted by David Gainer | 15 Comments
Sunday, October 09, 2005 9:46 PM

Wrapping up new visualizations – icon sets

The final visualization that we added to Excel 12 has the working title “icon sets”. As the name implies, this feature allows users to put icons in cells based on the values of the cell. These are in some ways similar to data bars and colour scales, so
Posted by David Gainer | 18 Comments
Thursday, October 06, 2005 11:45 AM

We now return to conditional formatting - what’s a colour scale?

The second new visualization that we have added to Excel 12 is something we are calling “colour scales” (again, that may change later when we finish official feature naming). It shares a lot with data bars as described in a previous post – it is a comparison
Posted by David Gainer | 22 Comments
More Posts Next page »
 
Page view tracker