Tech Support Guy banner
Cancel

Solved: Sort by color???

2538 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
D
If you just need to change all the cells in the sheet to the same colour you can do that easily with the format command.
If you just need to change one of many colours, a simple VB macro can test all cells and change just matching ones.
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