Hi

Have a look he
http://www.cpearson.com/excel/banding.htm

It may be what you want.
Andy.

"Str8" wrote in message
...
I have a spreadsheet thats connected to an Access DB. I have the
spreadsheet
set up so one row is white and the next row is a light grey. So basically
every other row is light grey. Lets say I hit refresh and more records get
brought in(meaning more rows get added). What happens is the formatting
for
the new rows are what ever the formatting was for the last row before I
hit
refresh. Is it possible to set it up to keep the last 2 rows format so the
new rows stay this same one white and one grey.
Hope this makes sence.

Thanks