microsoft.com: How to use conditional formatting to shade every other row in Excel
So often in Excel, I find that I need to create a spreadsheet that has many rows of information that requires a bit more legibility. Of course, I've seen pages where every other row of the spreadsheet is highlighted or shaded to make it easier to read. You could just go to each row and highlight by hand, but if you have pages and pages of data, this isn't very efficient. After all, we are in the age of automation. I'm not quite sure why Microsoft didn't build this feature into a more usable feature within Excels Format menu, but at least they gave us a way to do it.
In a nutshell:
- On the Format menu, click Conditional Formatting.
- Under Condition 1, select Formula Is.
- In the data entry box, type =MOD(ROW(),2)=1.
- Click the Format button. In the Format Cells dialog box, click the Patterns tab.
- Select a readable color, and then click OK.
- In the Conditional Formatting dialog box, click OK.
You may need to tweak it to your needs, but this is the basic way to do it.
For you people who don't mind doing a little programming in Visual Basic to create a macro:
http://support.microsoft.com/kb/213616/
Happy shading.
No comments:
Post a Comment