Help - Search - Members - Calendar
Full Version: excel
BleepingComputer.com > Software > Business Applications
   
ramsey76
I have a large excel file and font color has value. For example, a black font means the device is active, red tfont terminated and blue font is on hold. Is there a way to sort items by font color. Currently these items are randomly placed in the file. Ther is no another to tell the items apart except by font color.
Budapest
You could try this:

http://www.ozgrid.com/VBA/Sort.htm

I've never used it before so try it at your own risk.
AdamV
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.