#1  
Old 01-12-2009, 02:11 PM
service_call service_call is offline
Member
 
Join Date: May 2005
Posts: 96
Sort Rows By Highlight Color in Excel

I have a large Excel 2003 file that has some yellow-highlighted rows. I would love to be able to sort this file by row color. Anyone know and easy answer to my dilemma??


Thanks in advance
Reply With Quote
  #2  
Old 01-12-2009, 05:33 PM
Sunny's Avatar
Sunny Sunny is offline
Forum Moderator
 
Join Date: Aug 2002
Posts: 37,294
I believe in Excel 2007 there are more options for sorting by color. But as far as I know not in previous versions of Excel.

http://www.cpearson.com/excel/SortByColor.aspx
http://grok.lsu.edu/Article.aspx?articleId=511
__________________
~Sunny
Reply With Quote
  #3  
Old 01-12-2009, 06:35 PM
MMFELL's Avatar
MMFELL MMFELL is offline
Retired Computer Techo
 
Join Date: Nov 2003
Location: Sydney. Australia
Posts: 16,636
How are the rows formatted, conditional formatting?
Otherwise its macro time see http://www.ozgrid.com/VBA/Sort.htm and http://www.cpearson.com/excel/SortByColor.aspx
__________________
2.67 GHz Intel Core2 Quad 2GB RAM, 150GB + 500GB + 2TB SATA + 1TB Ext, DVD-RW, WinXP Pro (SP3), IE7, Avira, Outpost Firewall, Nero 7, Office XP. Cable. Pics of my Radar & Parrish now retired therapy dogs below.
Google is your friend


Reply With Quote
  #4  
Old 01-13-2009, 08:09 AM
service_call service_call is offline
Member
 
Join Date: May 2005
Posts: 96
Sort Rows By Highlight Color in Excel

Thanks everyone for your help. I am on it!
Reply With Quote
  #5  
Old 01-13-2009, 08:49 AM
Sunny's Avatar
Sunny Sunny is offline
Forum Moderator
 
Join Date: Aug 2002
Posts: 37,294
You're welcome.
__________________
~Sunny
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2000-2011 WorldStart, Inc