Sort by colour?

[Bill]

I have a large list of medical products which i purchase
every month along with price and number used each month.
These come from 8 diferent companies
I have a sheet for each company and produce monthly totals
on a summary sheet
The products can be used for several types of case...
Arterial,Venous, Gastro or Pediatric.
To make it easier to spot a product when putting in the
months figures I coloured the products by use...
Arterial red, Venous blue etc.
I have now been asked to produce costings for Venous
procedures for the last several years
It would be a snip if i could use the colour of the cell
to sort the items.
Is there any way to sort these items by the colour of the
row?
excel must store information about the colour of a cell
somewhere but i can find no info.

 

[Andy B]

Bill

Try Chip's site: http://www.cpearson.com/excel/SortByColor.htm

Andy.

 

[bill]

Thanks andy

I appreciate the speedy reply... I was going to check back
tomorrow but you answered while i'm still at my desk
regards
bill