Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help Forums Windows Startup Programs Database Virus, Spyware, and Malware Removal Guides Computer Tutorials Uninstall Database File Database Computer Glossary Computer Resources
 

Welcome Guest ( Log In | Click here to Register a free account now! )



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

> excel, sort by font color
ramsey76
post Nov 3 2009, 12:41 PM
Post #1


Forum Regular
***

Group: Members
Posts: 211
Joined: 15-November 05
Member No.: 40,724
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.
Go to the top of the page
 
+Quote Post
 
 Start new topic
Replies (1 - 2)
Budapest
post Nov 4 2009, 03:39 AM
Post #2


Bleepin' Cynic
******

Group: BC Advisor
Posts: 10,531
Joined: 11-November 06
Member No.: 94,959
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
Go to the top of the page
 
+Quote Post
AdamV
post Nov 4 2009, 12:16 PM
Post #3


Member
**

Group: BC Advisor
Posts: 47
Joined: 4-November 09
From: Leeds, UK
Member No.: 398,528
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, MCAS:I, MBMSS, CWNA, COS (I like to have lettuce after my name)
My personal blog - Getting IT right
Go to the top of the page
 
+Quote Post
« Next Oldest · Business Applications · Next Newest »
 

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version Time is now: 21st November 2009 - 09:20 PM


Advertise   |   About Us   |   Terms of Use   |   Privacy Policy   |   Contact Us   |   Site Map   |   Chat   |   Tutorials   |   Uninstall List
Discussion Forums   |   The Computer Glossary   |   Resources   |   RSS Feeds   |   Startups   |   The File Database   |   Virus Removal Guides

© 2003-2009 All Rights Reserved Bleeping Computer LLC.

Powered By IP.Board © 2009  IPS, Inc.