Excel Conditional Formatting
It’s a feature I have found handy in one major place: highlighting every other row in an excel sheet. You’d think they would have a button to do it, but conditional formatting is a suitable alternative.
- Highlight the area to apply the formatting to (all of it in my case)
- Go to Format->Conditional Formatting.
- Change the drop-down value to “Formula Is”
- Enter “=MOD(ROW(),2)=0″ (without the quotes) into the formula box.
- Click the formatting button and choose your format, and you’re done!
This information taken from Microsoft’s Help site.
I hear that formatting of any sort is being removed from Vista to get to production faster ….