http://blogs.msdn.com/jongallant/archive/2009/06/17/how-to-highlight-rows-based-on-a-cell-value-in-excel.aspxHere’s how to highlight rows based on a cell value in Excel 2007 and Excel 2010.&#160; Reference this page for previous versions of Excel &#160; 1) Select the table you want to apply the custom formatting to 2) Go to the Conditional Formatting ribbonen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/jongallant/archive/2009/06/17/how-to-highlight-rows-based-on-a-cell-value-in-excel.aspx#9926414Fri, 20 Nov 2009 20:02:13 GMT91d46819-8472-40ad-a661-2c78acb4018c:9926414Evgeny<p>Great tip!!!</p> <p>Thank you much!</p> <p>Have been looking for some time before I found this - very useful extension of standard conditional formatting highlight rules.</p>