how can i sort colour in a sheet Regards
N Nick Hodge Jan 20, 2008 #2 George If you have Excel 2007, this functionality is built-in, with versions prior you will need code Some examples here http://www.cpearson.com/excel/SortByColor.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] web: www.nickhodge.co.uk web: www.excelusergroup.org
George If you have Excel 2007, this functionality is built-in, with versions prior you will need code Some examples here http://www.cpearson.com/excel/SortByColor.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] web: www.nickhodge.co.uk web: www.excelusergroup.org
F FSt1 Jan 20, 2008 #3 hi, excel does not have a built in function for this but many users have long wanted this and many creating ways have been developed. It is usually done with the aid of a helper column. see this site...... http://cpearson.com/excel/colors.htm regards FSt1
hi, excel does not have a built in function for this but many users have long wanted this and many creating ways have been developed. It is usually done with the aid of a helper column. see this site...... http://cpearson.com/excel/colors.htm regards FSt1
