I am working with a 20,000 line spreadsheet of clothing - style, color,
sizes, etc. I have already done sorts to get my products in a consecutive
listing the way I want.

Now, is there a way to separate, highlight, or underline or something
whenever a style changes? I might have a list of 50 of one style, 30 of
another style and want to designate somehow the end of a partiacular style.
Maybe even insert a column and have just the style print once, at the
beginning of a group of the same style....

Thanks

Chip,

Assume your styles start in cell B7 AND continue down in column B.

You can enter a "conditional" format formula similar to:

=$B7<>$B6

that applies a desired color, font, fill and/or number format when the
condition is met.

The cell can then be copied and a Paste Special | Formats can be applied to
all cells
that you want to contain the conditional formating.

For example, if the conditional format applies a bright yellow fill and a
bold font to cell B7, then ALL cells that you apply the Paste Special |
Format to will also have this format if the row they are in is the first row
of a new style.

I hope this helps.

Good Luck.

"Chip" wrote:

> I am working with a 20,000 line spreadsheet of clothing - style, color,
> sizes, etc. I have already done sorts to get my products in a consecutive
> listing the way I want.
>
> Now, is there a way to separate, highlight, or underline or something
> whenever a style changes? I might have a list of 50 of one style, 30 of
> another style and want to designate somehow the end of a partiacular style.
> Maybe even insert a column and have just the style print once, at the
> beginning of a group of the same style....
>
> Thanks

Chip

Check out the subtotal function under the data menu. you may need to do
something stupid like 'count' the products, but you will then have a
hierarchy that can be expanded and contracted using the '+' in the row area
and you can also set this up to start a new page in print at each change in
subtotal.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Chip" <Chip@discussions.microsoft.com> wrote in message
news:27C35BE1-F243-4DE3-A955-236A317C960F@microsoft.com...
> I am working with a 20,000 line spreadsheet of clothing - style, color,
> sizes, etc. I have already done sorts to get my products in a consecutive
> listing the way I want.
>
> Now, is there a way to separate, highlight, or underline or something
> whenever a style changes? I might have a list of 50 of one style, 30 of
> another style and want to designate somehow the end of a partiacular
> style.
> Maybe even insert a column and have just the style print once, at the
> beginning of a group of the same style....
>
> Thanks