HOW TO conditionally format entire row/s based on a cell's text value in Excel 2007

I found that Conditionally Formatting an entire row/s rather than a single cell and that too  based on a text value in a cell rather than a numeric value in Excel 2007 is not straight forward. After a bit of monkeying around I learnt you can also actually have multiple Formulas while specifying a Rule for Conditional Formatting.

I jotted down the steps to do this with screen shots and posted them on my Code Gallery.

If you know of a simpler or alternative way to Conditionally Format an entire row in Excel 2007, please let me know.

Also see:

HOW TO create an Excel 2007 Macro

HOW TO create a Ribbon-less Excel 2003 UI in Excel 2007