Separating groups in spreadsheet

[Chip]

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

 

[ND Pard]

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.

 

[Nick Hodge]

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
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk