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