How do I sort an Excel Spreadsheet by background colour?
538436
Copy the code here: http://www.ozgrid.com/VBA/Sort.htm and follow the instructions in the middle of the page that begin: "To use this UDF push Alt+F11..."
967626
EXCELL - Spreadsheets
669633
do you mean you want to sort them? well, you just need to search for sort algorithm. There are some that needs mentioning, like QuickSort and Bubble sort, the first being are the fastest but most complicated and the latter simplest but inefficient. \n\nQuickSort is sorting by choosing some middle value (randomly, or for more efficiency, chosing the approximate median), and checking other value, if it is larger than the current value, it's put after the middle value, if it's smaller, it's put in before the middle value, if it's equal, it's up to programmer want to put it at low or high value (basically, seperating data smaller than middle value and larger value.). Then the data collection in the smaller value and the bigger value is sorted individually. Gradually, this will sort the datas. However, it is widely known that, when working with smaller amount of data, quicksort has a huge overhead, and usually when the data is small enough, the program switch to other sorting method.\n\nVisual on QuickSort\n1 5 6 8 4 7 5 9 6 5 1 2 4 7 8 9 'initial data\n1 5 6 8 4 7.5.9 6 5 1 2 4 7 8 9 'choose midvalue 5\n1 4 1 2 4.5.5 6 8 7 9 6 5 7 8 9 'seperate low and high value\nlow1= 1 4 1 2 4, high1=5 5 9 8 7 6 8 7 9 6 5 'sort low first\nlow1 = 1 4 1.2.4 'mid value = 2\nlow1 = 1 1 2 4 4 'low1 sorted\n1 1 2 4 4, high1=5 5 9 8 7 6 8 7 9 6 5 'sort high\nhigh1=5 5 9 8.7.6 8 7 9 6 5 'middle value = 7\nlow2=6 5 6 5 high2 =7 9 8 7 9 8 'sort low\nlow2=6 5 6 5 ' middle value 5\nlow2=5 5 6 6 ' sorted\n5 5 6 6, high2 =7 9 8 7 9 8 'sort high\nhigh2 =7 9 8 7 9 8 'middle value 8\nhigh2 =7 7 8 8 9 9 'sorted\n\nlow1 = 1 1 2 4 4\nlow2=5 5 6 6\nhigh2 =7 7 8 8 9 9 \n\nassemble these together:\n1 1 2 4 4 5 5 6 6 7 7 8 8 9 9 \n\nPhew, QuickSort really is NOT for human. It's hard for human to sort using quicksort, but relatively easy for computer, using self-calling functions\n\n~~~~~~~~~\n\nBubble sort is sorting algorithm by comparing a value, to it's next value. If the next value is smaller than the current value, it is swapped, if the next value is larger it do nothing. Then move to the next pair, until the last pair. Then repeat the process from the first data until all data is sorted.\n\nVisual on Bubble Sort:\n15 43 64 61 57 67 89 74 65 'initial data\n15 43 64 61 57 67 89 74 65 'check 15 and 43, do nothing\n15 32 43 71 57 67 89 74 65 'check 43 and 32, swap\n15 32 43 71 57 67 89 74 65 'check 43 and 71, do nothing\n15 32 43 57 71 67 89 74 65 'check 71 and 57, swap\n15 32 43 57 67 71 89 74 65 'check 71 and 67, swap\n15 32 43 57 67 71 89 74 65 'check 71 and 89, do nothing\n15 32 43 57 67 71 74 89 65 'check 89 and 74, swap\n15 32 43 57 67 71 74 65 89 'check 89 and 65, swap\n15 32 43 57 67 71 74 65 89 'repeat process\n15 32 43 57 67 71 74 65 89 'check 15 to 74 is already sorted\n15 32 43 57 67 71 65 74 89 'check 74 and 65, swap\n15 32 43 57 67 71 65 74 89 'check 74 to 89 is already sorted\n15 32 43 57 67 71 65 74 89 'check 15 to 71 is already sorted\n15 32 43 57 67 65 71 74 89 'check 71 and 65, swap\n15 32 43 57 67 65 71 74 89 'check 71 to 89 is already sorted\n15 32 43 57 67 65 71 74 89 'check 15 to 67 is already sorted\n15 32 43 57 67 65 71 74 89 'check 67 and 65, swap\n15 32 43 57 67 65 71 74 89 'check all data sorted\n\nNote: in this one, I rather lucky, the random data I used is rather already almost sorted. Bubble sort is slowest when a data is already sorted, but reversed to what it should have been sorted, while fastest when the values are almost sorted.\n\nTrivia: the name bubble sort come since in bubble sort, the higher data is like a bubble, it goes up and up, while the lower value goes down and down
135478
This is cool.  Use the Print Area function.  From File menu, choose Print Area.  Choose to clear it, first of all.  Then highlight all the portions of your spreadsheet that you wish to print.  \n\nYou can highlight sections that are not next to each other (noncontiguous) by using the CTRL key while blocking w/the mouse.  So, for example, use the mouse to highlight columns A and B.  Let go of the mouse button and see that those areas are highlighted. Without doing anything more (don't click anywhere, don't use an arrow key, etc.), press down the CTRL key and then click on column D. You will then see that columns A,B and D are highlighted (but not C).  You can choose your own print area in this fashion.  \n\nAfter you've gotten your print area highlighted, go to the File menu, choose Print Area, and choose Set Print Area.  Now only the things that were highlighted are going to print.  You can see this on the print preview screen. \n\nEnjoy!
1077362
Use the "fill".  So highlight the cell then use the brush to fill in the color that you want.  It should work!
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
1005550
Use excel, somewhat easy and really organized
740830
Easy:\n\n1) Click on FORMAT\n2) Choose SHEET\n3) Choose Background\n4) Navigate to the picture you want and choose it.\n5) Click OK\n\n\nHope this helps!\n\nRegards,\nQwertyKPH @ Yahoo!
532438
You can use the =MAX and =LARGE functions to identify the five highest scores without resorting each time.  (This will add five rows to your spreadsheet (one for the highest, another for the second highest, etc.) but you can then hide these rows if they are cluttering up the spreadsheet.)  Then total these amounts and divide by 5.
606125
sort the data by cell phone number\n\ninset a column to the right of the number column.\n\nin the first cell, enter this formula:\n=if(a1=a2,1,0)\nwhere "a" refers to the column with the numbers.\n\nhighlight the cell with the formula.  copy it.\npaste is all the way down to the end of the column.\n\nhighlight the column with the formulas.  copy it.  go to the edit menu, choose paste special and choose values.\n\nsort data by the column with the 1s and 0s in it.  anything with a 1 is a duplicate.
772673
Have you considered using a listbox instead? A listbox has the sorted property on it if you need it.\n\nMore detail : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconcomboboxcontrol.asp\n\nHope that helps!
128871
Its an awkward one because of the browser differences (why does everything come down to this???)\n\nDefine both the colour and the background at the same time\n<hr style="color:#f00; background: #f00">\nas apparently IE uses the color attribute and mozzilla (ghecko I presume) browsers use the background attribute.\n\nAck.. Go take a peek at the link site ;O)\n\n-----------\n\nWell if you want to use style sheets then create a new file called css.inc (or whatever you want it to be called) and place it in your directory with the following code in it.\n\nhr{color:#f00;background:#f00}\n\njust that line, nothing else needed except other style commands if you want to use them.\n\nThen in the <head></head> area of 'all' your pages put\n\n<link rel="stylesheet" href="/css.inc" type="text/css" />\n\nThis is the best way to control an entire site to keep all your pages following the same style/rules.\n\nYou could even go so far as to put another command in the line to give the stylesheet a title\n\n<link rel="stylesheet" href="/css.inc" type="text/css" title="Main style" />\n\nwhich would then show up in browsers when selecting a stylesheet to use.\nA further step on from this would then be to create alternate styles and looks that a user can choose between by using\n\n<link rel="alternate stylesheet" href="/css2.inc" type="text/css" media="all" title="A different look" />\n\nbut this is probably getting into the realms of tmi ;O)
175683
try customizing one of the ones from MS Office\n\nhttp://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=order+form
965931
u can do it by sorting, filtering i know , other participants already gave u that so i'm including this one\n\nfor largest value \n=MAX(B1:B3)\n\nnote the reference value of this cell in the left top \n\nfor corresponding day \n=LOOKUP(cell reference value of max,B1:B3,A1:A3)\n\ni think it's the best answer
645072
Select the range of cells you want to sort. Select Data-Sort.  Select the Column you want to sort by. (next sort col etc) then select Ascending Descending and click OK.  If you have selected a header row select that option to make sure it does not get sorted and mixed with data.  Good luck.
738891
A simple way is to make the cell a colour until it is filled with an amount.  You can do this through conditional formating under  Format.  For example if you say Cell value is equal to 0 then  format the cell Red.  If you put in a value other than 0 the red will disappear.
36439
I guess this must help you\n\nhttp://www.exceltip.com/st/Color_numbers_based_on_the_value_result_in_Microsoft_Excel/74.html\n\nSo you might want to first select all cells in Excel an then format it to some color that you want text to appear in.\n\nNext you do this steps for selecting any of the colors for numbers.\n\nExample: [BLUE] #,##0 ;[RED](#,##0)\n\n\nYou can choose same color again and again.