Sorting by Colors

E

emillay9

Multiple answers to this question -but if you don't know what the heck a UDF
is, or how to program the column once you've done that -- then how can you do
this?
Would someone of a genius nature care to be explicit and really give step by
step directions so a beginner could actually do this and make it work? I
have now spent over 2 hours going from Pearson's site to the other site and
working working working and no to avail. I'm just not smart enough to make
it go without better directions.. so I would appreciate any and all help -
even privately. Thank you!
 
D

Dave Peterson

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Short course:

Open your workbook.
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

Now go back to excel.
Into a test cell and type:
(if you want the fill color)
=ColorIndexOfCell(a1)
(or if you want the font color)
=ColorIndexOfCell(a1,true)

If that works ok, then just fill up a helper column with your formula and sort
by that.
 
J

Jim Cone

e,

My Special Sort Excel add-in will sort by cell color or font color.
Plus it has 20 more ways to sort not readily available in Excel.
It works like and somewhat resembles the existing Excel sort utility.
It comes with a Word.doc install/use file and is - free.
Just email me and ask for it. Remove XXX from my email address.

Jim Cone
San Francisco, USA
[email protected]


"emillay9" <[email protected]>
wrote in message
Multiple answers to this question -but if you don't know what the heck a UDF
is, or how to program the column once you've done that -- then how can you do
this?
Would someone of a genius nature care to be explicit and really give step by
step directions so a beginner could actually do this and make it work? I
have now spent over 2 hours going from Pearson's site to the other site and
working working working and no to avail. I'm just not smart enough to make
it go without better directions.. so I would appreciate any and all help -
even privately. Thank you!
 
Top