| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
I HAVE AN EXCEL SPREADSHEET THAT HAS SHADED ROWS. EVERY OTHER ROW IS SHADED
GREY. IS THERE A WAY TO FORMAT A WORKSHEET SO THAT WHEN A ROW IS ADDED, IT AUTOMATICALLY HAS THE EVERY OTHER ROW SHADING FORMAT SO THAT YOU DO NOT HAVE TO GO BACK A RE-SHADE EVERY OTHER ROW GREY? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
Use format painter icon and copy down as far as needed
"LOTLITA64" wrote: I HAVE AN EXCEL SPREADSHEET THAT HAS SHADED ROWS. EVERY OTHER ROW IS SHADED GREY. IS THERE A WAY TO FORMAT A WORKSHEET SO THAT WHEN A ROW IS ADDED, IT AUTOMATICALLY HAS THE EVERY OTHER ROW SHADING FORMAT SO THAT YOU DO NOT HAVE TO GO BACK A RE-SHADE EVERY OTHER ROW GREY? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
Please drop the all caps.........hard to read and even harder on the ears.
Select a bunch of rows then............ FormatConditional FormattingFormula is: enter the following. =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to a nice color. This will retain the row formatting throughout sorting or filtering. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 10:53:07 -0800, LOTLITA64 wrote: I HAVE AN EXCEL SPREADSHEET THAT HAS SHADED ROWS. EVERY OTHER ROW IS SHADED GREY. IS THERE A WAY TO FORMAT A WORKSHEET SO THAT WHEN A ROW IS ADDED, IT AUTOMATICALLY HAS THE EVERY OTHER ROW SHADING FORMAT SO THAT YOU DO NOT HAVE TO GO BACK A RE-SHADE EVERY OTHER ROW GREY? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
And will retain the banding when inserting or deleting rows.
Gord On Fri, 25 Jan 2008 11:40:14 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Please drop the all caps.........hard to read and even harder on the ears. Select a bunch of rows then............ FormatConditional FormattingFormula is: enter the following. =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to a nice color. This will retain the row formatting throughout sorting or filtering. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 10:53:07 -0800, LOTLITA64 wrote: I HAVE AN EXCEL SPREADSHEET THAT HAS SHADED ROWS. EVERY OTHER ROW IS SHADED GREY. IS THERE A WAY TO FORMAT A WORKSHEET SO THAT WHEN A ROW IS ADDED, IT AUTOMATICALLY HAS THE EVERY OTHER ROW SHADING FORMAT SO THAT YOU DO NOT HAVE TO GO BACK A RE-SHADE EVERY OTHER ROW GREY? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I filter on rows that are shaded in a different color? | Excel Worksheet Functions | |||
| filter rows with shaded cells | Excel Discussion (Misc queries) | |||
| shaded rows | Excel Discussion (Misc queries) | |||
| Shaded Rows | New Users to Excel | |||
| How to select only odd/even numbered rows to be shaded | Excel Discussion (Misc queries) | |||
Linear Mode
