document.write('<div class="feedburnerFeedBlock" id="microsoft/dqmren18k612ok5e2ge56jla5jn8g0">');
document.write('<p class="feedTitle">Excel 2007 Conditional Formatting</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb286672(office.11).aspx" target="_blank" >Conditional Formatting: Adding Customized Rules to Excel 2007</a></span>');
document.write('<div>Summary: The conditional formatting user interface (UI) in Excel 2007 now makes it easier than ever to create rules that increase the impact of your data. Learn how to take ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb226688(office.11).aspx" target="_blank" >Conditional Formatting: Adding Custom Conditional Formatting to Excel ...</a></span>');
document.write('<div>One of the exciting enhancements in Microsoft Office Excel 2007 is improvements to conditional formatting. By using conditional formatting in Office Excel 2007, you can apply ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/04/16/modifying-conditional-formatting-color-ranges-in-excel-2007.aspx" target="_blank" >Microsoft Excel : Modifying Conditional Formatting Color Ranges in ...</a></span>');
document.write('<div>Today\u2019s 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb404903.aspx" target="_blank" >Setting Conditional Formatting in Excel 2007</a></span>');
document.write('<div>Summary: Learn how to apply conditional formatting programmatically in Excel 2007.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/tags/Conditional+Formatting/default.aspx" target="_blank" >2007 Conditional Formatting</a></span>');
document.write('<div></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb428945(office.11).aspx" target="_blank" >Conditional Formatting: Adding Customized Color Scales to Excel 2007</a></span>');
document.write('<div>Summary: Color scales give you an opportunity to create visual effects in your data to see how the value of a cell compares with the values in a range of cells. Learn how to ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/07/19/670684.aspx" target="_blank" >Microsoft Excel : Fun With Conditional Formatting</a></span>');
document.write('<div>In this respect, Excel 2007 does a reasonably good job. For example, on the Conditional Formatting menu you can choose to highlight cells containing duplicates, unique values, top ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb229709(office.11).aspx" target="_blank" >Conditional Formatting: Adding Customized Data Bars to Excel 2007</a></span>');
document.write('<div>Summary: Data bars give you an opportunity to create visual effects in your data that can help you see how the value of a cell compares with other cells. Learn how to implement and ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/05/09/594200.aspx" target="_blank" >Microsoft Excel : Conditional Formatting Trick 2 \u2013 How to get an ...</a></span>');
document.write('<div>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 \u201Cicon set ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/09/20/762792.aspx" target="_blank" >Microsoft Excel : Conditional Formatting Trick 3 \u2013 The percentmin ...</a></span>');
document.write('<div>Folks that have been using data bars ( see here for more information) in Excel 2007 sometimes bump into a situation where the size of the bar painted by Excel on the smallest value ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/08/14/699841.aspx" target="_blank" >Microsoft Excel : Conditional Formatting Compatibility</a></span>');
document.write('<div>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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/02/24/538875.aspx" target="_blank" >Microsoft Excel : Conditional Formatting Trick 1 \u2013 Multi-Coloured ...</a></span>');
document.write('<div>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 \u201Cdata bar ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/182189" target="_blank" >How to create a conditional format to hide errors in Excel</a></span>');
document.write('<div>In Microsoft Office Excel 2007, you can use the IFERROR function to simplify ... In the Conditional Formatting dialog box, click Condition 1, and then click Formula Is.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2005/10/06/477948.aspx" target="_blank" >Microsoft Excel : We now return to conditional formatting - what\u2019s a ...</a></span>');
document.write('<div>November 2007 (4) October 2007 (4) ... in the \"Insert name\" dialog, Excel marks the range defined by your formula, so you can see whether it\'s right. The conditional formatting ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2007/10/01/data-bars-feedback-please.aspx" target="_blank" >Microsoft Excel : Data Bars \u2013 Feedback Please</a></span>');
document.write('<div>Excel 2007 has a conditional formatting feature that graphically displays bars in a cell to represent the value of the cell. This feature is called Data Bars.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/08/11/new-conditional-formatting-features-in-excel-2010.aspx" target="_blank" >Microsoft Excel : More Conditional Formatting Features in Excel 2010</a></span>');
document.write('<div>In Excel 2007, errors in the range would lead to conditional formatting not being applied to all the cells in the range. Users told us that this was frustrating. In Excel 2010 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb899438(office.11).aspx" target="_blank" >Bringing Improvements to Tables in Excel 2007 (Part 4 of 6)</a></span>');
document.write('<div>For more information about conditional formatting, see Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007. In addition to filtering by color, Excel 2007 also ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb970934(office.11).aspx" target="_blank" >Bringing Improvements to Tables in Excel 2007 (Part 6 of 6)</a></span>');
document.write('<div>Excel 2007 Developer Reference; Conditional Formatting: Adding Customized Color Scales to Excel 2007; Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb736198(office.11).aspx" target="_blank" >Bringing Improvements to Tables in Excel 2007 (Part 2 of 6)</a></span>');
document.write('<div>As you add new rows to the table, either in the middle or at the end, or as you delete rows, Excel 2007 automatically extends or contracts the conditional formatting rule ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/office_hours/archive/2009/01/06/jenni-french-find-trends-faster-with-excel-2007.aspx" target="_blank" >Office Hours Blog : Jenni French: Find trends faster with Excel 2007</a></span>');
document.write('<div>Lucky for us, a few features in Excel 2007 make it easier to spot trends, find meaning, and tell a story with numbers. My new favorite Excel feature is Conditional Formatting.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/268568" target="_blank" >How to use conditional formatting to shade every other row in Excel</a></span>');
document.write('<div>Article ID: 268568 - Last Review: January 27, 2007 - Revision: 5.3 ... For more information about conditional formatting, click Microsoft Excel Help on the Help menu, type change, add ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.iconsets.aspx" target="_blank" >Workbook.IconSets Property (2007 System) (2007 System)</a></span>');
document.write('<div>Gets the collection of built-in icon sets that can be used to apply a conditional formatting rule to a range in the workbook.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb238836.aspx" target="_blank" >AddIconSetCondition Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb963879(office.11).aspx" target="_blank" >Bringing Improvements to Tables in Excel 2007 (Part 5 of 6)</a></span>');
document.write('<div>Excel 2007 Developer Reference; Conditional Formatting: Adding Customized Color Scales to Excel 2007; Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/office/aa905419.aspx" target="_blank" >Excel 2007</a></span>');
document.write('<div>Saving Workbooks to PDF and XPS Formats in Excel 2007; Setting Conditional Formatting in Excel 2007; Using the VLookup Function in Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="https://blogs.msdn.com/excel/archive/2009/08/05/icon-set-improvements-in-excel-2010.aspx" target="_blank" >Microsoft Excel : Icon Set Improvements in Excel 2010</a></span>');
document.write('<div>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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/mikekelly/archive/2008/12/30/excel-conditional-formatting-against-a-goal-value.aspx" target="_blank" >MikeKelly\'s WebLog : Excel Conditional Formatting Against a Goal Value</a></span>');
document.write('<div>October 2007 (3) August 2007 (3) July 2007 (1) April 2007 (1) January 2007 (1) ... Excel Conditional Formatting Against a Goal Value. Today, for a metrics worksheet I\'m doing, I had a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb693324(office.11).aspx" target="_blank" >Bringing Improvements to Tables in Excel 2007 (Part 1 of 6)</a></span>');
document.write('<div>Excel 2007 Developer Reference; Conditional Formatting: Adding Customized Color Scales to Excel 2007; Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/12/22/more-msdn-content-that-may-be-useful.aspx" target="_blank" >Microsoft Excel : More MSDN Content That May Be Useful</a></span>');
document.write('<div>I have been getting a lot of Excel Services questions lately (along with a bunch on setting up Analysis Services to work with Excel 2007 and a raft on conditional formatting), so I ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="https://blogs.msdn.com/excel/archive/2009/08/07/data-bar-improvements-in-excel-2010.aspx" target="_blank" >Microsoft Excel : Data Bar Improvements in Excel 2010</a></span>');
document.write('<div>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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://code.msdn.microsoft.com/odcxl2007h2/Release/ProjectReleases.aspx?ReleaseId=2529" target="_blank" >Excel 2007: Visual How Tos: Code Samples - Release: Setting ...</a></span>');
document.write('<div>Setting Conditional Formatting in Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb242310.aspx" target="_blank" >IconSetCondition Object Members\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents an icon set conditional formatting rule. ... Name Description; Delete: Deletes the specified conditional formatting rule object.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/07/16/excel-2010-the-10-000-ft-view.aspx" target="_blank" >Microsoft Excel : Excel 2010 \u2013 The 10,000 ft. View</a></span>');
document.write('<div>Excel 2007 debuted brand new conditional formatting features and a revamped charting engine. In Excel 2010 we have continued to innovate in the area of data visualization with ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2008/09/05/video-tip-conditional-formatting-and-data-validation.aspx" target="_blank" >Microsoft Excel : Video Tip: Conditional Formatting and Data ...</a></span>');
document.write('<div>December 2007 (4) November 2007 (4) October 2007 (4) September 2007 (4) ... The topic is an Excel tip about using conditional formatting and data validation to turn on and off the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb215760.aspx" target="_blank" >Priority Property\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb224174.aspx" target="_blank" >AboveAverage Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents an above average visual of a conditional formatting rule. Applying a color or fill to a range or selection to help you see the value of a cells relative to other cells.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb238795.aspx" target="_blank" >IconSetCondition Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents an icon set conditional formatting rule. Version Information Version Added: Excel 2007. Remarks. All conditional formatting objects are contained within a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb224195.aspx" target="_blank" >ColorScale Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents a color scale conditional formatting rule. Version Information Version Added: Excel 2007. Remarks. All conditional formatting objects are contained within a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb178540.aspx" target="_blank" >Top10 Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2005/10/11/479713.aspx" target="_blank" >Microsoft Excel : New conditional formatting \"rules\" ...</a></span>');
document.write('<div>October 2007 (4) September 2007 (4) August 2007 (7) May 2007 (1) April ... Note, in Excel 12, you can still create the conditional formatting rules types from Excel 2003.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/08/11/694891.aspx" target="_blank" >Microsoft Excel : Compatibility Checker</a></span>');
document.write('<div>Eric is writing about compatibility in Excel 2007. As introduced in the last post ... Conditional Formatting \"Some cells have more conditional formats than are supported by the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb833052(office.11).aspx" target="_blank" >Bringing Improvements to Tables in Excel 2007 (Part 3 of 6)</a></span>');
document.write('<div>Excel 2007 Developer Reference; Conditional Formatting: Adding Customized Color Scales to Excel 2007; Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/973823" target="_blank" >Conditional formatting rules are duplicated when you copy and then ...</a></span>');
document.write('<div>Fixes a problem in which duplicated rules are created when you copy and then paste cells that have conditional formatting applied in Excel 2007.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2005/10/12/480431.aspx" target="_blank" >Microsoft Excel : Conditional formatting meets the ribbon</a></span>');
document.write('<div>October 2007 (4) September 2007 (4) August 2007 (7) May 2007 (1) ... prominent place in the UI, so we put the entry point for conditional formatting on the first tab in the new Excel ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/919194" target="_blank" >How to shade every other row in an Excel 2007 worksheet</a></span>');
document.write('<div>Describes how to shade every other row in an Excel 2007 worksheet. ... Method 2: Use the Conditional Formatting option To use the Conditional Formatting option to shade ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://download.microsoft.com/download/6/7/3/673B71D0-6D4F-4591-9940-D33DF9135487/BIN303_Excel_Charting_Stevens_Baytopp.pptx" target="_blank" >Slide 1</a></span>');
document.write('<div>What\u2019s New in Excel 2007 Data Visualization. Demos. Top\/Bottom Conditional Formatting. Conditional Coloring of Proportional Data Bars. Heatmaps</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/dmahugh/archive/2007/10/02/conditional-formatting.aspx" target="_blank" >Doug Mahugh : Conditional Formatting</a></span>');
document.write('<div>Scott Ruble has a post on on the Excel team blog today, asking for feedback on the databars functionality that was introduced in Excel 2007. This is a very popular new capability ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/inside_office_online/archive/2009/03/19/time-savers-iii-remove-duplicate-values-in-excel.aspx" target="_blank" >Inside Office Online blog : Time Savers III: Remove duplicate values ...</a></span>');
document.write('<div>Here\'s another article that saves Excel customers time, according to verbatim feedback: Locate duplicates by using conditional formatting (Excel 2003) The Excel 2007 version covers ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb224235.aspx" target="_blank" >IconSet Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents a single set of icons that are used in an icon set conditional formatting rule. Version Information Version Added: Excel 2007. Remarks</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb238843.aspx" target="_blank" >SetLastPriority Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.</div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/dqmr"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');