How sorting by color in Excel can be done?

Answer 1

You cannot get it to sort by colour as such. What you can do is use something like a different number to represent different colours. In the cell next to each colour, you would put the number for that colour. Then you would select the cells with the colours and with the numbers and then sort by the column with the numbers in it, and it will put everything in the order you want.

So say you wanted things sorted so that first everything that was Blue, then Orange, then Green then Red, you'd give Blue the number 1, Orange 2, Green 3 and Red 4. So say you had put them into cells like this. Then in the cell beside each colour, you would put the number for that colour.

Blue

Red

Green

Blue

Red

Orange

Red

Green

Blue

Orange

Red

Green

Blue

Orange

Green

Red

Blue

Red

Green

Orange

Then in the cell beside each colour, you would put the number for that colour.

Having done that you would select the cells with the colours and the numbers, so you'd have two columns selected. Then you can either hit one of the sort keys on the toolbar or go to the Data menu and pick the sort option and choose to sort by the column with the numbers in them. When they are sorted you could then just delete the numbers and leave the things in the order you want.