Separating groups in spreadsheet

  • Thread starter Thread starter Chip
  • Start date Start date
C

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
 
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

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
 
Back
Top