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://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/2009/04/16/modifying-conditional-formatting-color-ranges-in-excel-2007.aspx" target="_blank" >Microsoft Excel 2010 : Modifying Conditional Formatting Color Ranges ...</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://blogs.msdn.com/excel/archive/2006/07/19/670684.aspx" target="_blank" >Microsoft Excel 2010 : 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://blogs.msdn.com/excel/archive/tags/Conditional+Formatting/default.aspx" target="_blank" >blogs.msdn.com</a></span>');
document.write('<div></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 2010 : 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/category/11358.aspx" target="_blank" >Microsoft Excel 2010 : Conditional Formatting</a></span>');
document.write('<div>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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb407306(office.11).aspx" target="_blank" >Conditional Formatting: Adding Customized Icon Sets to Excel 2007</a></span>');
document.write('<div>Summary: Icon sets give you an opportunity to create visual effects in your data to see how the value of a cell compares with other cells. Learn how to implement and manipulate ...</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/05/09/594200.aspx" target="_blank" >Microsoft Excel 2010 : Conditional Formatting Trick 2 \u2013 How to get ...</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://www.microsoft.com/downloads/details.aspx?FamilyId=4BDAEDA8-A6C3-4D4E-9516-B6026850CC43&displaylang=en" target="_blank" >Download details: Excel 2007 Demo: Data Takes Shape with Conditional ...</a></span>');
document.write('<div>Watch this demo and see how Microsoft Office Excel 2007 makes it easier than ever to apply rich conditional formatting.</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 2010 : Conditional Formatting Trick 3 \u2013 The ...</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://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/2006/02/24/538875.aspx" target="_blank" >Microsoft Excel 2010 : Conditional Formatting Trick 1 \u2013 Multi ...</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://blogs.msdn.com/excel/archive/2009/08/11/new-conditional-formatting-features-in-excel-2010.aspx" target="_blank" >Microsoft Excel 2010 : More Conditional Formatting Features in Excel ...</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://blogs.msdn.com/excel/archive/2007/10/01/data-bars-feedback-please.aspx" target="_blank" >Microsoft Excel 2010 : 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/2005/12/21/506626.aspx" target="_blank" >Microsoft Excel 2010 : PivotTable VII: \u2013 Conditional formatting gets ...</a></span>');
document.write('<div>October 2007 (4) September 2007 (4) August 2007 (7) May 2007 (1) April ... To make it very easy to choose the \u201Cscope\u201D of a conditional formatting rule in a PivotTable, Excel 12 ...</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://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://blogs.msdn.com/excel/archive/2005/10/06/477948.aspx" target="_blank" >Microsoft Excel 2010 : We now return to conditional formatting - what ...</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/sharepointdesigner/archive/2007/11/09/an-introduction-to-conditional-formatting.aspx" target="_blank" >Microsoft SharePoint Designer Team Blog : An Introduction to ...</a></span>');
document.write('<div>SharePoint Designer 2007 doesn\u2019t have the same icon sets features that you get with Excel 2007, but you can achieve the same results using conditional formatting.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/08/05/icon-set-improvements-in-excel-2010.aspx" target="_blank" >Microsoft Excel 2010 : 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://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://support.microsoft.com/kb/895562" target="_blank" >The conditional formatting may be set incorrectly when you use VBA in ...</a></span>');
document.write('<div>Microsoft Office Excel 2007. Start Excel, and then open a new Excel worksheet. In the Excel worksheet, select cell B1. Click the Home tab. Click Conditional Formatting in the Styles ...</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://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://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://www.microsoft.com/downloads/info.aspx?na=22&p=19&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d4bdaeda8-a6c3-4d4e-9516-b6026850cc43%26DisplayLang%3den" target="_blank" >www.microsoft.com</a></span>');
document.write('<div></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/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://www.microsoft.com/downloads/info.aspx?na=22&p=24&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d4bdaeda8-a6c3-4d4e-9516-b6026850cc43%26DisplayLang%3den" target="_blank" >www.microsoft.com</a></span>');
document.write('<div></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://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/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://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://blogs.msdn.com/excel/archive/2009/08/07/data-bar-improvements-in-excel-2010.aspx" target="_blank" >Microsoft Excel 2010 : 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://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://social.msdn.microsoft.com/Forums/en-US/officedevelopmentprerelease/thread/fc6a3ad1-a216-48c8-8e2d-bcad38fb29c1/" target="_blank" >Use of xlUniqueValues with setting conditional formatting rules in ...</a></span>');
document.write('<div>Use of xlUniqueValues with setting conditional formatting rules in VBscript for Excel 2007</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb238791.aspx" target="_blank" >Icon Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents a single icon in an icon set used in a conditional formatting rule. Version Information Version Added: Excel 2007. Remarks. The Icon object is returned from the Item ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/" target="_blank" >Microsoft Excel 2010</a></span>');
document.write('<div>When Excel 2007 introduced a new charting engine into the ... your existing workbooks that contain charts, conditional formatting, or other things that render and work fine in Excel ...</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://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://msdn.microsoft.com/en-us/library/bb238798.aspx" target="_blank" >IconSets Object\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents a collection of icon sets 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/bb178644.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('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/category/14416.aspx" target="_blank" >Microsoft Excel 2010 : Backwards Compatibility</a></span>');
document.write('<div>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.</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://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://msdn.microsoft.com/en-us/library/bb238841.aspx" target="_blank" >SetFirstPriority Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Sets the priority value for this conditional formatting rule to \"1\" so that it will be evaluated before all other rules on the worksheet.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/bobmeyers/archive/2009/07/31/add-excel-like-color-scale-conditional-formatting-to-your-reports.aspx" target="_blank" >Bob\'s SQL Reporting Services Blog : Add Excel-like \"color scale ...</a></span>');
document.write('<div>October 2007 (1) September 2007 (1) February 2007 (2) January 2007 (1) ... Add Excel-like \"color scale\" conditional formatting to your reports. I\u2019ve been meaning to do this for a long ...</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>');
