document.write('<div class="feedburnerFeedBlock" id="microsoft/gQZS05tgq66f9plip6n723vvt753es">');
document.write('<p class="feedTitle">Conditional Formatting</p>');
document.write('<ul>');
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://support.microsoft.com/kb/268568" target="_blank" >How to use conditional formatting to shade every other row in Excel</a></span>');
document.write('<div>This article describes how to use conditional formatting to shade every other row in an Excel spreadsheet.</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>Describes how to create conditional formatting on a cell or on a range of cells so that error values are not displayed in the cell(s).</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>Discusses a workaround for a problem that occurs in Excel in which conditional formatting may be set incorrectly when you use a VBA macro.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/215986" target="_blank" >XL2000: PivotTable Does Not Preserve Conditional Formatting</a></span>');
document.write('<div>When you refresh or pivot fields in your PivotTable report, conditional formats do not move with the field(s) to which they are applied. Instead conditional formats remain in the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/154874" target="_blank" >XL97: How to Create a Conditional Format to Hide Errors</a></span>');
document.write('<div>In Microsoft Excel, you can create conditional formatting on a cell, or a range of cells, so that error values are not displayed in the cell(s).</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://support.microsoft.com/kb/173216" target="_blank" >XL97: Conditional Formatting Unexpectedly Applied to Text</a></span>');
document.write('<div>In Microsoft Excel 97, if you apply conditional formatting to a range of cells, the conditional formatting may unexpectedly be displayed in cells in the range that contain text.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/270099" target="_blank" >XL2001: Conditional Formatting in Column Settings Is Not Adjusted When ...</a></span>');
document.write('<div>When you use copy and paste to create a copy of a list that contains conditional formatting, the conditional formatting in the new list works correctly. However, when you double ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/268412" target="_blank" >XL2001: Undo of Cut and Paste of Cells with Conditional Formats Doesn ...</a></span>');
document.write('<div>When conditional formatting is applied to a cell in Microsoft Excel, and the cell is cut and pasted to another location, undoing the paste may not correctly update the conditional ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/215156" target="_blank" >XL2000: Programmatically Changing Conditional Formatting Returns ...</a></span>');
document.write('<div>When you use Microsoft Visual Basic code to remove the background color property of the conditional formatting of a cell, you receive unexpected results when you try to re-apply ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/272874" target="_blank" >XL2001: Conditional Format in Column Settings Is Not Adjusted</a></span>');
document.write('<div>When you apply conditional formatting to a column in a list and the condition contains a relative reference, the reference is set for the first cell in the column. If you insert a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/156892" target="_blank" >Excel Stops After Specifying Conditional Format</a></span>');
document.write('<div>In the Conditional Formatting dialog box, click OK. The message box appears several times, and the screen stops updating the display. However, menus are still available.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/185319" target="_blank" >XL98: Error Using Add-In Function in Conditional Formatting</a></span>');
document.write('<div>When you click OK in the Conditional Formatting dialog box, you may receive the following error message:</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/185318" target="_blank" >XL97: Error Using Add-In Function in Conditional Formatting</a></span>');
document.write('<div>When you click OK in the Conditional Formatting dialog box, you may receive the following error message:</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/211749" target="_blank" >XL2000: Conditional Number Format Not Shifted in Group Edit Mode</a></span>');
document.write('<div>In Microsoft Excel, you may not be able to shift conditional formatting to another column when the worksheets are grouped. When you have selected more than one worksheet, and you ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/211617" target="_blank" >XL2000: Error Using Add-In Function in Conditional Formatting</a></span>');
document.write('<div>When you click OK in the Conditional Formatting dialog box, you may receive the following error message:</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://support.microsoft.com/kb/178965" target="_blank" >XL98: Conditional Format Applies Format for First Condition</a></span>');
document.write('<div>When you use Conditional Formatting, only the format for the first condition is applied. Second and\/or third conditions are ignored.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/169022" target="_blank" >XL97: Conditional Formatting Not Saved When Saving as HTML</a></span>');
document.write('<div>If you save your workbook as an HTML document, some of the cell formatting may not be saved with the workbook.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/186676" target="_blank" >XL98: How to Create a Conditional Format to Hide Errors</a></span>');
document.write('<div>In Microsoft Excel, you can apply conditional formatting to a cell or a range of cells so that error values are not displayed in the cells.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb255919.aspx" target="_blank" >ColorScale Object Members\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents a color scale 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://support.microsoft.com/kb/924186" target="_blank" >Excel may apply conditional formatting only to the first character or ...</a></span>');
document.write('<div>Describes the fact that Excel may apply conditional formatting only to the first character or to the first few characters of a string instead of to all the characters of a string.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb224734.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://support.microsoft.com/kb/157938" target="_blank" >XL97: Conditional Format Applies Format for First Condition</a></span>');
document.write('<div>When you use Conditional Formatting, only the format for the first condition is applied. Second and\/or third conditions are ignored.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/170586" target="_blank" >XL97: Conditional Number Format Not Shifted in Group Edit Mode</a></span>');
document.write('<div>In Microsoft Excel, when you select more than one worksheet, and then insert a new column, conditional number formatting may not be shifted to the next column. The conditional ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/178958" target="_blank" >XL98: Conditional Number Format Not Shifted in Group Edit Mode</a></span>');
document.write('<div>In Microsoft Excel 98 Macintosh Edition, when you select more than one worksheet, and then insert a new column, conditional number formatting may not be shifted to the next column.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=280&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>How to use conditional formatting to shade every other row in Excel This article describes how to use conditional formatting to shade every other row in an Excel spreadsheet.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/179034" target="_blank" >XL98: Conditional Formatting Is Not Saved When You Save as HTML</a></span>');
document.write('<div>If you save a workbook as a Hypertext Markup Language (HTML) document, some of the cell formatting may not be saved with the workbook.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb224539.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://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://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://support.microsoft.com/kb/211901" target="_blank" >XL2000: Conditional Formats May Not Work on Rich Text Cells</a></span>');
document.write('<div>If you apply a Conditional Number format to a cell, the formatting that you specified may not be applied to the entire cell contents when the condition for that format is met in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/181724" target="_blank" >XL98: Comparison Value Changed from Fraction to Serial Number</a></span>');
document.write('<div>If you enter a comparison value for a condition in the Conditional Formatting dialog box, the value may be changed if you close and reopen the Conditional Formatting dialog box.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/165865" target="_blank" >XL97: Comparison Value Changed from Fraction to Serial Number</a></span>');
document.write('<div>If you enter a comparison value for a condition in the Conditional Formatting dialog box, the value may be changed if you close and reopen the Conditional Formatting dialog box.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/211894" target="_blank" >XL2000: Comparison Value Changed from Fraction to Serial Number</a></span>');
document.write('<div>If you enter a comparison value for a condition in the Conditional Formatting dialog box, the value may be changed if you close and reopen the Conditional Formatting dialog box.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/231125" target="_blank" >XL2000: Invalid Page Fault Saving Shared Workbook That Contains ...</a></span>');
document.write('<div>When you save a shared workbook that contains conditional formatting, you may receive the following error message: This program has performed an illegal operation and will be shut ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/215783" target="_blank" >XL: \"Excel Could Not Save All the Data and Formatting\" Error Message</a></span>');
document.write('<div>In Microsoft Excel, if you format a large selection with conditional formatting and then save the file, you may receive the following error message: Excel could not save all the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/165493" target="_blank" >XL97: Conditional Formats May Not Work on Rich Text Cells</a></span>');
document.write('<div>If you apply a Conditional Number format to a cell, the formatting that you specified may not be applied to the entire cell contents when the condition for that format is met in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb148112.aspx" target="_blank" >Font Property\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns a Font object that specifies the font formatting if the conditional formatting rule evaluates to True. Read-only.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/171237" target="_blank" >XL97: Conditional Format Reapplied After Inserting Cut Cells</a></span>');
document.write('<div>Note that Microsoft Excel 97 applies the conditional formatting to the cells you inserted below the original cell with the conditional formatting.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb255939.aspx" target="_blank" >ConditionValue Object Members\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb148105.aspx" target="_blank" >Borders Property\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns a Borders collection that specifies the formatting of cell borders if the conditional formatting rule evaluates to True. Read-only.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb238831.aspx" target="_blank" >AddColorScale Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns a new ColorScale object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225807.aspx" target="_blank" >New Members and Constants\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. PTCondition: Returns a Boolean value indicating if the conditional ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225810.aspx" target="_blank" >New Objects, Collections, and Enumerations\u00A0[Excel 2007 Developer ...</a></span>');
document.write('<div>Represents a color scale conditional formatting rule. ColorScaleCriteria: A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb242308.aspx" target="_blank" >IconSet Object Members\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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb238838.aspx" target="_blank" >AddTop10 Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns a Top10 object representing a conditional formatting rule for the specified range.</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>Method 2: Use the Conditional Formatting option To use the Conditional Formatting option to shade rows in a worksheet, follow these steps: Open the worksheet.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb255970.aspx" target="_blank" >Databar Object Members\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('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/gQZS"><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>');