Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
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.

Photo

excel


  • Please log in to reply
2 replies to this topic

#1 ramsey76

ramsey76

  • Members
  • 227 posts
  • OFFLINE
  •  
  • Local time:05:48 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)

 


#2 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,579 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:08:48 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

AdamV

  • Members
  • 65 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Leeds, UK
  • Local time:11:48 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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users