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: