B bshred New Member Joined Nov 16, 2002 Messages 24 Nov 24, 2005 #1 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
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
B Big Monkey Active Member Joined Nov 5, 2005 Messages 255 Nov 24, 2005 #2 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
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
B bshred New Member Joined Nov 16, 2002 Messages 24 Nov 24, 2005 #3 Thanks Big Monkey, problem solved with the video.
B Big Monkey Active Member Joined Nov 5, 2005 Messages 255 Nov 24, 2005 #4 No problem Happy Thanksgiving!