Sorting by Format

[bshred]

Hi there

I have a column of cells, some of which are coloured a particular shade of yellow. How do I sort by or select only those cells, so that I can paste them elsewhere?

Cheers

 

[Big Monkey]

Here is a neat video I found in the Wiki which I saw a couple of weeks ago.

http://www.mrexcel.com/wiki/index.php?n=ExcelWiki.SortByColorWithoutAnAdd-in

 

[bshred]

Thanks Big Monkey, problem solved with the video.

 

[Big Monkey]

No problem

Happy Thanksgiving!