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.



emillay9 wrote:

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!

--

Dave Peterson