Just some things I've learned...
Friday, 6 August 2010
MS Excel Alternate Row formatting
Colour alternate rows in MS Excel. Select the whole area choose Format > Conditional Formatting... and Add a new conditional formula, selecting the desired colour.
=MOD(ROW(),2)
Easy and if you add new rows it updates the colours automatically.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment