Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2014, 02:11 AM
gasyoun gasyoun is offline Is it possible to sort cells in shades of colors? Windows 7 32bit Is it possible to sort cells in shades of colors? Office 2007
Novice
 
Join Date: Apr 2013
Posts: 5
gasyoun is on a distinguished road
Default


Quote:
Originally Posted by excelledsoftware View Post
That will give you a number for each of the colors. Now I am guessing that you want each of those colors to grouped ie. Reds with reds, blues with blues etc. The colorindex will not quite do that but you can sort the numbers and change them as you wish to sort them after.
There are 24k colors. Do I understand you right, that you propose to sort them manually? Even RGB gives you blue that can look like grey, because of the intensity. Can color and color intensity be taken into account? I'm a big fan of manual labor in Excel. But 24 000 rows is too many even for me.

http://labs.tineye.com/color/001c85d...True&height=32 does an interesting job, but still no enough.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to sort cells in shades of colors? How to Sort Table Cells from Left to Right tamaracklodge Word Tables 4 03-04-2013 04:00 AM
Is it possible to sort cells in shades of colors? Unable to change font colors from theme colors choy Word 3 08-01-2012 09:12 PM
Is it possible to sort cells in shades of colors? Auto Colors in Cells? Learner7 Excel 5 07-06-2010 10:55 PM
How can I change the colors of cells automatically based on Job Completion? Learner7 Excel 0 07-06-2010 10:47 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft