Highlight every other line
 

Im trying Highlight every other line to be shaded grey, does anyone now
formula that will do this all at once?

Octet

Highlight every other line
 

hi
see this site....
http://www.cpearson.com/excel/banding.htm

regards
FSt1

"Octet32" wrote:

Im trying Highlight every other line to be shaded grey, does anyone now
formula that will do this all at once?

Octet

Highlight every other line
 

Select a great gaggle of rows then FormatConditional FormattingFormula is:

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Select a gray format and OK your way out.


Gord Dibben MS Excel MVP


On Fri, 29 Feb 2008 05:15:01 -0800, Octet32
wrote:

I’m trying Highlight every other line to be shaded grey, does anyone now
formula that will do this all at once?

Octet