Preserve format

S

Str8

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
 
D

Duke Carey

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 Format>Conditional 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.
 
S

Str8

Ill give these a try thank you.

Duke Carey said:
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 Format>Conditional 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.
Click to expand...
 
Top