Sort by colour?

  • Thread starter Thread starter Bill
  • Start date Start date
B

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