HOW TO conditionally format entire row/s based on a cell's text value in Excel 2007
| Tweet |
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:
This entry was posted
on
Saturday, December 06, 2008.
You can skip to the end and leave a
response.
»Post a Comment