Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

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.

Latest News: Survey Reveals Users Have No Clue About Router Security

Featured Deal: Get 96% off the MCSA SQL Server Training Deal

excel

Started by ramsey76 , Nov 03 2009 12:41 PM

Please log in to reply

2 replies to this topic

#1 ramsey76

Members
227 posts
OFFLINE

Local time:03:06 AM

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.

BC AdBot (Login to Remove)

BleepingComputer.com
Register to remove ads

#2 Budapest

Bleepin' Cynic

Moderator
23,573 posts
OFFLINE

Gender:Male
Local time:06:06 PM

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

Members
65 posts
OFFLINE

Gender:Male
Location:Leeds, UK
Local time:09:06 AM

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

Back to Business Applications