excel

BleepingComputer.com: excel

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

excel sort by font color

#1 ramsey76

Forum Regular

Group: Members
Posts: 214
Joined: 15-November 05

Posted 03 November 2009 - 12:41 PM

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.

#2 Budapest

Bleepin' Cynic

Group: Moderator
Posts: 21,855
Joined: 11-November 06
Gender:Male

Posted 04 November 2009 - 03:39 AM

You could try this:

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

I've never used it before so try it at your own risk.

_{The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw}

#3 AdamV

Member

Group: Members
Posts: 65
Joined: 04-November 09
Gender:Male
Location:Leeds, UK

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'Farrell

Professional geek, consultant and trainer.
MCT, MCSA, MMI, MBMSS, CWNA, COS (I like to have lettuce after my name)
My personal blog - Getting IT right

BleepingComputer.com: excel