Tech Support Guy banner
Cancel

Solved: Sort by color???

2539 Views 5 Replies 4 Participants Last post by  Callisto012, 
C
I was given an Excel doc where the creator color coded changes in data that I need to fix.
There are about 300 rows and the data I need to update is scattered all over.

Is there anyway to sort by color?

That would save me a LOT of time! :D

Thanks for any and all help. :up:
Save
Like
Status
Not open for further replies.
1 - 1 of 6 Posts
Zack Barresse
Well, the thread title dictates I post these, just for anybody who may be searching...

Sort by color:
http://www.cpearson.com/excel/SortByColor.htm

Autofilter by color:
http://vbaexpress.com/kb/getarticle.php?kb_id=230
Save
Like
1 - 1 of 6 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top