Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with alternating table rows
I have created a table and applied a table style with alternating banded
rows. When I convert it to a range in order to use the subtotals feature, the banding does not alternate anymore. In addition, when I convert the range back to a table and try to reaply the banded rows format, nothing happens. I also tried reapplying the entire table style, but again without success. Is there any way to restore the correct banded row order? It looks to me like the row colors were converted to permanent highlighted rows when the table was converted to a normal range. Thanks for any help. Linda -- Linda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with alternating table rows
You might try creating your color banding by utilizing Conditional
Formatting. That way, rows are colored solely dependent on their row number. Select the cells to be included in the banding, say A1 to J100. Then: <Format <Conditional Format Change "Cell Value Is" to "Formula Is", then enter: =MOD(ROW(),2)=0 Click on "Format", and choose your Pattern color for the rows, then <OK <OK The above formula colors the *even* rows within the selection. To color the *odd* numbered rows, use: =MOD(ROW(),2)=1 OR To color every 3 rows, try: =MOD(ROW(),3)=0 You'll see that this banding will withstand the restructuring of your data. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Linda" wrote in message ... I have created a table and applied a table style with alternating banded rows. When I convert it to a range in order to use the subtotals feature, the banding does not alternate anymore. In addition, when I convert the range back to a table and try to reaply the banded rows format, nothing happens. I also tried reapplying the entire table style, but again without success. Is there any way to restore the correct banded row order? It looks to me like the row colors were converted to permanent highlighted rows when the table was converted to a normal range. Thanks for any help. Linda -- Linda |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with alternating table rows
Yes, I have been reaading in other messages about doing that. However, I was
hoping there was a solution to restoring the correct alternating pattern that was applied using the table style (I am using Excel 2007). Seems as if once the range is converted back to a table, that you should be able to at least reapply the design style and get it back to the correct alternating pattern. I thought maybe there is something wrong with my installation of Excel. Linda -- Linda "Ragdyer" wrote: You might try creating your color banding by utilizing Conditional Formatting. That way, rows are colored solely dependent on their row number. Select the cells to be included in the banding, say A1 to J100. Then: <Format <Conditional Format Change "Cell Value Is" to "Formula Is", then enter: =MOD(ROW(),2)=0 Click on "Format", and choose your Pattern color for the rows, then <OK <OK The above formula colors the *even* rows within the selection. To color the *odd* numbered rows, use: =MOD(ROW(),2)=1 OR To color every 3 rows, try: =MOD(ROW(),3)=0 You'll see that this banding will withstand the restructuring of your data. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Linda" wrote in message ... I have created a table and applied a table style with alternating banded rows. When I convert it to a range in order to use the subtotals feature, the banding does not alternate anymore. In addition, when I convert the range back to a table and try to reaply the banded rows format, nothing happens. I also tried reapplying the entire table style, but again without success. Is there any way to restore the correct banded row order? It looks to me like the row colors were converted to permanent highlighted rows when the table was converted to a normal range. Thanks for any help. Linda -- Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill rows with alternating data ? | Excel Discussion (Misc queries) | |||
Alternating BG colors between groups of rows | Excel Discussion (Misc queries) | |||
Alternating shading of varying groups of rows | Excel Discussion (Misc queries) | |||
shade alternating rows in excel | Excel Discussion (Misc queries) | |||
Alternating colors for rows | Excel Discussion (Misc queries) |