Excel formatting of lines

[Leonard -Fly]

Was looking for a way to have excel format evey other or every two lines in a shadded format instead of having lines (borders) on the spread sheet.

Any suggestions....

Lenny


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Nick Hodge]

Lenny

You could use conditional formatting, Highlight the cells and select
'Formula is' and enter

=MOD(ROW(),2)

and format the 'Pattern' as you like. This will 'band' the rows

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk


in message
news:[email protected]...

 

[Mickey Mouse]

Alternatively you might want to look at ASAP utilities.
http://www.asap-utilities.com/download-asap-utilities.php
However although ASAP will do it for you, what Nick is suggesting below is
actually teaching something.

Mickey