Sort by colour coding
Posted by Len Clarke on August 21, 2001 9:06 AM
I have a list with various items of information about customers held in each row eg A1=Surname, A2=Chritian name, A3=Address
One of my staff helpfully filled each row in a colour which identified the product each had purchased eg all purchasers of Product X are coloured Blue, Product Y=Yellow etc. However, there are no details on the worksheet, other than the colour that identify which product they purchased.
So, the question is, can I sort the data by the colour used to infill the cells?