Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Conditional Formatting   (RSS)
Thursday, April 16, 2009 5:08 PM

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,
Posted by Joseph Chirilov | 3 Comments
Attachment(s): HSL_Color_Modifier6.zip
Friday, September 05, 2008 1:47 PM

Video Tip: Conditional Formatting and Data Validation

Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago, Joseph had a blog post about community clips on OfficeLabs.com , so for this post, I wanted to take advantage of the video demonstration
Posted by Joseph Chirilov | 8 Comments
Attachment(s): CFandDV.xlsx
Thursday, August 21, 2008 11:39 AM

Using Excel 2007 for Progress Tracking in the Classroom

Today's author, Danny Khen, a Program Manager on the Excel team, discusses a solution he recently built using Excel. The Manual Spreadsheet Spreadsheets are the bread and butter of running the business world, where PCs are ubiquitous. The possibility,
Posted by Joseph Chirilov | 7 Comments
Attachment(s): ProgressTracking.xlsm
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 | 14 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 | 28 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 | 13 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 | 19 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 | 17 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 | 18 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 | 15 Comments
More Posts Next page »
 
Page view tracker