| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Fill Color
Hello,
Is it possible to sort cells by fill colors without writing VBA? I'm using Excel version 2003 -- Thank you... Elaine |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Fill Color
See http://xldynamic.com/source/xld.Colo...r.html#sorting
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elaine" wrote in message ... Hello, Is it possible to sort cells by fill colors without writing VBA? I'm using Excel version 2003 -- Thank you... Elaine |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Fill Color
Elaine,
The next version of Excel (out next year) will be able to do that. Otherwise, VBA is required. A commercial alternative, from yours truly, was reviewed by The Office Letter... http://www.officeletter.com/blink/specialsort.html -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Elaine" wrote in message... Hello, Is it possible to sort cells by fill colors without writing VBA? I'm using Excel version 2003-- Thank you... Elaine |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Fill Color
Hello again,
I tried your formula, =colorindex(a1) and got the #NAME? message. What did I do wrong? -- Thank you... Elaine "Bob Phillips" wrote: See http://xldynamic.com/source/xld.Colo...r.html#sorting -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elaine" wrote in message ... Hello, Is it possible to sort cells by fill colors without writing VBA? I'm using Excel version 2003 -- Thank you... Elaine |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Fill Color
Did you add the UDF that was also supplied?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elaine" wrote in message ... Hello again, I tried your formula, =colorindex(a1) and got the #NAME? message. What did I do wrong? -- Thank you... Elaine "Bob Phillips" wrote: See http://xldynamic.com/source/xld.Colo...r.html#sorting -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elaine" wrote in message ... Hello, Is it possible to sort cells by fill colors without writing VBA? I'm using Excel version 2003 -- Thank you... Elaine |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Fill Color
Got it working. Read details from the website and it works like a champ!
-- Thank you .. Elaine "Bob Phillips" wrote: Did you add the UDF that was also supplied? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elaine" wrote in message ... Hello again, I tried your formula, =colorindex(a1) and got the #NAME? message. What did I do wrong? -- Thank you... Elaine "Bob Phillips" wrote: See http://xldynamic.com/source/xld.Colo...r.html#sorting -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elaine" wrote in message ... Hello, Is it possible to sort cells by fill colors without writing VBA? I'm using Excel version 2003 -- Thank you... Elaine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I sort Excel sheet by the color of the fill in selected cell | Excel Worksheet Functions | |||
| Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
| Testing for Cell Fill Color | Excel Worksheet Functions | |||
| I cannot see my fill color on my spread sheet. I disappears | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
Linear Mode
