I have inherited a worksheet, a rather large office directory, where every other line is highlighted. By highlighted, I mean the the row's background color is set to 15% gray. This issue is that when ever the directory is updated, it messes up the every-other-row-is-highlighted format. Other than going in and changing each row manually, is there a function/macro that will do this automatically on a selected area?

Thank you for any _constructive_ input you may have to offer.

Michael


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to