Excel Conditional Formatting
Monday, June 19th, 2006It’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.