Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/gQZS/~3/1HH0YywRnoA/bb404903.aspxSummary: Learn how to apply conditional formatting programmatically in Excel 2007.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/1HH0YywRnoA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb404903.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/LEHiC_dyiHk/268568This article describes how to use conditional formatting to shade every other row in an Excel spreadsheet.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/LEHiC_dyiHk" height="1" width="1"/>http://support.microsoft.com/kb/268568http://feedproxy.google.com/~r/microsoft/gQZS/~3/5vKBzkQ35Uc/182189Describes 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).<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/5vKBzkQ35Uc" height="1" width="1"/>http://support.microsoft.com/kb/182189http://feedproxy.google.com/~r/microsoft/gQZS/~3/UxvIQfvpCmM/215986When 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/UxvIQfvpCmM" height="1" width="1"/>http://support.microsoft.com/kb/215986http://feedproxy.google.com/~r/microsoft/gQZS/~3/J_WdPFEMB0Y/bb238836.aspxReturns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/J_WdPFEMB0Y" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb238836.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/tnq8G1ARFxo/154874In 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).<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/tnq8G1ARFxo" height="1" width="1"/>http://support.microsoft.com/kb/154874http://feedproxy.google.com/~r/microsoft/gQZS/~3/lZab8pWEiRM/270099When 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/lZab8pWEiRM" height="1" width="1"/>http://support.microsoft.com/kb/270099http://feedproxy.google.com/~r/microsoft/gQZS/~3/hQFp0y6krEA/215156When 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/hQFp0y6krEA" height="1" width="1"/>http://support.microsoft.com/kb/215156http://feedproxy.google.com/~r/microsoft/gQZS/~3/ixq-JmJCFUY/268412When 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/ixq-JmJCFUY" height="1" width="1"/>http://support.microsoft.com/kb/268412http://feedproxy.google.com/~r/microsoft/gQZS/~3/KhKvOMcEITY/215241When you format a cell with conditional formatting, and then format the first character in the cell with another format (such as a different font size, color, or underline), the ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/KhKvOMcEITY" height="1" width="1"/>http://support.microsoft.com/kb/215241http://feedproxy.google.com/~r/microsoft/gQZS/~3/UzysH9OFZpo/272874When 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/UzysH9OFZpo" height="1" width="1"/>http://support.microsoft.com/kb/272874http://feedproxy.google.com/~r/microsoft/gQZS/~3/6o2djaitTTY/156892In 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/6o2djaitTTY" height="1" width="1"/>http://support.microsoft.com/kb/156892http://feedproxy.google.com/~r/microsoft/gQZS/~3/TVD0wBP00Rg/185319When you click OK in the Conditional Formatting dialog box, you may receive the following error message:<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/TVD0wBP00Rg" height="1" width="1"/>http://support.microsoft.com/kb/185319http://feedproxy.google.com/~r/microsoft/gQZS/~3/5lK4p3CcJqY/185318When you click OK in the Conditional Formatting dialog box, you may receive the following error message:<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/5lK4p3CcJqY" height="1" width="1"/>http://support.microsoft.com/kb/185318http://feedproxy.google.com/~r/microsoft/gQZS/~3/josmRaxhPDQ/211749In 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/josmRaxhPDQ" height="1" width="1"/>http://support.microsoft.com/kb/211749http://feedproxy.google.com/~r/microsoft/gQZS/~3/jsyadLpY-S8/181901If you apply a conditional number format to a cell, and the condition for the format for the cell is met, Microsoft Excel may fail to apply the formatting that you specify to the ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/jsyadLpY-S8" height="1" width="1"/>http://support.microsoft.com/kb/181901http://feedproxy.google.com/~r/microsoft/gQZS/~3/ru1Q_K7seNM/211617When you click OK in the Conditional Formatting dialog box, you may receive the following error message:<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/ru1Q_K7seNM" height="1" width="1"/>http://support.microsoft.com/kb/211617http://feedproxy.google.com/~r/microsoft/gQZS/~3/Kuj3T669fJE/bb242310.aspxRepresents an icon set conditional formatting rule. ... Name Description; Delete: Deletes the specified conditional formatting rule object.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/Kuj3T669fJE" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb242310.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/YpkyztxR1aE/178965When you use Conditional Formatting, only the format for the first condition is applied. Second and/or third conditions are ignored.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/YpkyztxR1aE" height="1" width="1"/>http://support.microsoft.com/kb/178965http://feedproxy.google.com/~r/microsoft/gQZS/~3/VkMCtuu8SgI/169022If you save your workbook as an HTML document, some of the cell formatting may not be saved with the workbook.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/VkMCtuu8SgI" height="1" width="1"/>http://support.microsoft.com/kb/169022http://feedproxy.google.com/~r/microsoft/gQZS/~3/cPa5Ry8niEM/bb255919.aspxRepresents a color scale conditional formatting rule. ... Name Description; Delete: Deletes the specified conditional formatting rule object.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/cPa5Ry8niEM" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb255919.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/poGLAmDwoiw/924186Describes 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/poGLAmDwoiw" height="1" width="1"/>http://support.microsoft.com/kb/924186http://feedproxy.google.com/~r/microsoft/gQZS/~3/qs2v_QPJ-mU/bb224734.aspxReturns 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/qs2v_QPJ-mU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb224734.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/Nhtj4XKxoEQ/170586In 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/Nhtj4XKxoEQ" height="1" width="1"/>http://support.microsoft.com/kb/170586http://feedproxy.google.com/~r/microsoft/gQZS/~3/Q7mlSsE-tKA/2513How 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/Q7mlSsE-tKA" height="1" width="1"/>http://support.microsoft.com/ph/2513?sid=280&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/gQZS/~3/Z8ftLnhO7sU/179034If you save a workbook as a Hypertext Markup Language (HTML) document, some of the cell formatting may not be saved with the workbook.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/Z8ftLnhO7sU" height="1" width="1"/>http://support.microsoft.com/kb/179034http://feedproxy.google.com/~r/microsoft/gQZS/~3/6eu_9UaUI-w/bb178563.aspxSets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/6eu_9UaUI-w" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb178563.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/FH5u9w62vT4/973823Fixes a problem in which duplicated rules are created when you copy and then paste cells that have conditional formatting applied in Excel 2007.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/FH5u9w62vT4" height="1" width="1"/>http://support.microsoft.com/kb/973823http://feedproxy.google.com/~r/microsoft/gQZS/~3/ERsz4vI1qTA/bb238841.aspxSets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/ERsz4vI1qTA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb238841.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/0OfGnCqAnvA/211901If 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/0OfGnCqAnvA" height="1" width="1"/>http://support.microsoft.com/kb/211901http://feedproxy.google.com/~r/microsoft/gQZS/~3/Exjv3PVnxDc/178958In 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/Exjv3PVnxDc" height="1" width="1"/>http://support.microsoft.com/kb/178958http://feedproxy.google.com/~r/microsoft/gQZS/~3/JmfJ7mJxSfQ/181724If 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/JmfJ7mJxSfQ" height="1" width="1"/>http://support.microsoft.com/kb/181724http://feedproxy.google.com/~r/microsoft/gQZS/~3/gqf5h9C6X9U/165865If 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/gqf5h9C6X9U" height="1" width="1"/>http://support.microsoft.com/kb/165865http://feedproxy.google.com/~r/microsoft/gQZS/~3/Q_w8TBi6vnY/211894If 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.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/Q_w8TBi6vnY" height="1" width="1"/>http://support.microsoft.com/kb/211894http://feedproxy.google.com/~r/microsoft/gQZS/~3/jutjqsRSMQ4/231125When 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/jutjqsRSMQ4" height="1" width="1"/>http://support.microsoft.com/kb/231125http://feedproxy.google.com/~r/microsoft/gQZS/~3/vqcI9r3QIQ0/215783In 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/vqcI9r3QIQ0" height="1" width="1"/>http://support.microsoft.com/kb/215783http://feedproxy.google.com/~r/microsoft/gQZS/~3/AjLHJg_l_lo/165493If 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/AjLHJg_l_lo" height="1" width="1"/>http://support.microsoft.com/kb/165493http://feedproxy.google.com/~r/microsoft/gQZS/~3/CVpR6xreF-8/bb148112.aspxReturns a Font object that specifies the font formatting if the conditional formatting rule evaluates to True. Read-only.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/CVpR6xreF-8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb148112.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/S-0U5d0YuXY/171237Note that Microsoft Excel 97 applies the conditional formatting to the cells you inserted below the original cell with the conditional formatting.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/S-0U5d0YuXY" height="1" width="1"/>http://support.microsoft.com/kb/171237http://feedproxy.google.com/~r/microsoft/gQZS/~3/1wHKMzCmzA0/bb255939.aspxRepresents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/1wHKMzCmzA0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb255939.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/TNB-RMNEeCw/bb148105.aspxReturns a Borders collection that specifies the formatting of cell borders if the conditional formatting rule evaluates to True. Read-only.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/TNB-RMNEeCw" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb148105.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/1MJmjfXh8Io/bb225810.aspxRepresents a color scale conditional formatting rule. ColorScaleCriteria: A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/1MJmjfXh8Io" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb225810.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/CvHI3w8wR1Y/bb238831.aspxReturns 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/CvHI3w8wR1Y" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb238831.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/UsWqytBfiR0/bb225807.aspxThe priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. PTCondition: Returns a Boolean value indicating if the conditional ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/UsWqytBfiR0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb225807.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/ylSZtothGDQ/bb242308.aspxRepresents a single set of icons that are used in an icon set conditional formatting rule.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/ylSZtothGDQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb242308.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/VjHei6-yL_E/bb238838.aspxReturns a Top10 object representing a conditional formatting rule for the specified range.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/VjHei6-yL_E" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb238838.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/ZJf4DJheP98/919194Method 2: Use the Conditional Formatting option To use the Conditional Formatting option to shade rows in a worksheet, follow these steps: Open the worksheet.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/ZJf4DJheP98" height="1" width="1"/>http://support.microsoft.com/kb/919194http://feedproxy.google.com/~r/microsoft/gQZS/~3/bp-hsQb0W9I/bb255970.aspxReturns 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/bp-hsQb0W9I" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb255970.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/DNlKf_PUA_M/bb238834.aspxReturns a Databar object representing a data bar conditional formatting rule for the specified range.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/DNlKf_PUA_M" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb238834.aspxhttp://feedproxy.google.com/~r/microsoft/gQZS/~3/7SIQpzO0vws/bb238829.aspxReturns a new AboveAverage object representing a conditional formatting rule for the specified range.<img src="http://feeds.feedburner.com/~r/microsoft/gQZS/~4/7SIQpzO0vws" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb238829.aspx