To alternate row colors in Excel ...
|Select a range of cells to format ...|
|Click Conditional Formatting - Click New Rule|
|For the rule, enter this ...|
|Click the format button and select your formatting.|
|Click OK twice and there you go!|
|Only one little problem, you can't save your custom formulas, at least I havent figured out how yet.|