View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default 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