ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/80256-cell-formatting.html)

Str8

Cell Formatting
 
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


All times are GMT +1. The time now is 05:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com