Results for:
Conditional Formatting

• Using conditional formatting to highlight dates in Excel

  4 Apr 2013

  This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen , with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations...
• Impress your teacher: Use conditional formatting to highlight data (video)

  13 Jun 2012

  He's no slouch! Melvin Corpuscle shows his accounting teacher a thing or two by walking him through how he used conditional formatting to make low and high sales numbers stand out. Learn more about conditional formatting: Conditional Formatting Rules Simplified Quick start: Apply conditional formatting...
• Conditional Formatting Rules Simplified

  27 Feb 2012

  Thanks to Amit Velingkar for writing this blog post. (We are re-publishing this post first published in April 2010. Why? Because so many of you keep searching for it. This is the second in a series of oldies but goodies Excel posts.) Conditional formatting is a popular feature and is a great way to easily...
• Apollo 11 & Excel 2010 – Watch History Reimagined for a chance to win

  13 Jul 2011

  When you think about it, the ease with which we're able to process and visualize complex mathematics in the digital age is profound. Especially when you consider that it wasn't that long ago that much of this work was done manually. That got us thinking - what would it have been like if Excel had been...
• Free training: Take the next steps in growing your Excel skills

  28 Jun 2011

  In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder...
• Check it out: Options for using check marks in Excel

  14 Jun 2011

  Sometimes there's more than one way to get what you want. Take check marks, for example. In Excel, you have several options: You can use conditional formatting to display a list of binary values as green check marks or red Xs. If you want people to be able to check or uncheck a box, you can add a check...
• Easy budget management with Excel

  10 Jun 2011

  This is post #8 in the Ten Days of Office series celebrating the one-year anniversary of the release of Office 2010 with tips and tricks for getting the most from your Office experience. In today's economy, smart money management is a necessary skill. Whether managing the family budget , planning college...
• Make your data pop with conditional formatting

  17 May 2011

  You've got your numbers wrangled and organized just right, but they still don't jump out at the people who look at your worksheet. You want to give them the big picture at a quick glance. This is where conditional formatting can come to your rescue. The embedded workbook below shows three examples of...
• How it's Made: Tower Defense - a Game in Excel 2010

  27 Jul 2010

    This blog post is brought to you by Karen Cheng a Program Manager on the Excel team.     In today's post, we'll show you how the arcade game Tower Defense was created in an Excel spreadsheet (see a video of the game being played here ).  In this game, creeps move toward your castle...
• The DisplayFormat OM

  14 Aug 2009

  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 object to access the formatting of the cell. Selection...
• More Conditional Formatting Features in Excel 2010

  11 Aug 2009

  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 with references to a different sheet on the...
• Data Bar Improvements in Excel 2010

  7 Aug 2009

  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 range. Data bars are a great way of seeing trends...
• Icon Set Improvements in Excel 2010

  6 Aug 2009

  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 in each cell representing the value of the cell relative...
• Modifying Conditional Formatting Color Ranges in Excel 2007

  16 Apr 2009

  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...
• Video Tip: Conditional Formatting and Data Validation

  5 Sep 2008

  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 and do the post via community clips....
• Using Excel 2007 for Progress Tracking in the Classroom

  21 Aug 2008

  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, indeed even the need, to use spreadsheets in an environment...
• Tracking Split Costs

  28 Nov 2007

  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 multi-city tour of Europe that lasted a couple weeks...
• Data Bars – Feedback Please

  1 Oct 2007

  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 displays bars in a cell to represent the value of...
• Feedback Please - Conditional Formatting For Right-To-Left Sheets

  17 Aug 2006

  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 RTL - when a sheet direction is set to RTL, cell A1...
• Conditional Formatting Compatibility

  14 Aug 2006

  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 in previous posts what we have done; here...