Preserve format
 

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

Preserve format
 

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

Preserve format
 

It's probably more consistent if you use Conditional Formatting

Select the range of data, and plenty of rows below, too, if you expect much
more data to come in. No go to FormatConditional formatting. In the first
box select 'formula is' and use this in the next box

=mod(row(),2)=0

Click on the format button, go to the Patterns tab and select the light grey
you want. "OK" your way back to the spreadsheet & you'll find the formatting
as you like it.


"Str8" wrote:

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

Preserve format
 

Ill give these a try thank you.

"Duke Carey" wrote:

It's probably more consistent if you use Conditional Formatting

Select the range of data, and plenty of rows below, too, if you expect much
more data to come in. No go to FormatConditional formatting. In the first
box select 'formula is' and use this in the next box

=mod(row(),2)=0

Click on the format button, go to the Patterns tab and select the light grey
you want. "OK" your way back to the spreadsheet & you'll find the formatting
as you like it.


"Str8" wrote:

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