Posted 04 November 2009 - 12:16 PM
If you use Excel 2007 you can sort by colour.
Or rather, you can bring all the items of one colour to the top, so if you use a multi-level sort you can choose exactly what order to sort your items, by font or cell background colour.
Due to global warming, eskimos now have more than 20 words for water John O'FarrellProfessional geek, consultant and trainer.
MCT, MCSA, MMI, MBMSS, CWNA, COS (I like to have lettuce after my name)
My personal blog - Getting IT right