To alternate row colours
Steps as follows:
- Choose New Rule [Conditional Formatting, Styles, Home Tab]
- Click use a formula to determine which cells to format [Select a Rule Type]
- Enter formula: [Edit the Rule Description]
- =mod(row(),2)
- Set colours by clicking Format
- Use Fill Tab
Other alternating formulas as follows:
- 2 rows, =mod(row(),4)<2
- 3 rows, =mod(row(),6)<3
- ...
- ...
No comments:
Post a Comment