Conditional Formatting
Posts on Conditional Formatting
New features in conditional formatting extend to the object model as well. Excel has traditionally allowed users to access the formatting of their cells through the object model. For example, Users can use the interior class which lives off the range
Read More...
In this blog post I’ll walk through some of the new Conditional Formatting features in Excel 2010 such as: Cross-Sheet References Robust Error Handling Performance Enhancements Cross-Sheet References In Excel 2010, you can create conditional formatting
Read More...
Data Bars are a popular type of conditional formatting that was introduced in Excel 2007. The basic idea of data bars is that Excel draws a bar in each cell whose length corresponds to the value of the cell relative to the other cells in the selected
Read More...
Thanks to Amit Velingkar, a Program Manager on the Excel team, for putting together the next few posts on conditional formatting. In Excel 2007, we introduced Icon Sets - a new type of conditional formatting. The basic idea is that Excel draws an icon
Read More...
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,
Read More...
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
Read More...
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,
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
