Shade Alternate Rows using Conditional Formatting   —————————————————————————————————————————-   Shade Alternate Rows, including blank/unused range   Select worksheet range you wish to format   Home  ->  Conditional Formatting -> New Rule -> select “Use a formula to determine which cells to format” option (Excel 2007)   Format -> Conditional Formatting  ->  “Formula Is”  (earlier...