Hi Gary

check out
http://www.cpearson.com/excel/colors.htm
and
http://www.cpearson.com/excel/SortByColor.htm

Cheers
JulieD

"Gary" wrote in message
...
Hello!

I had a user at work who went through a large spreadsheet, and highlighted
the rows of which need to be looked at. Unfortunately, they highlighted
them and didn't insert any other information. As far as I know, you can't
sort based on color. I do know that I can create a macro to insert a value
into a cell based on the color of another cell. How would I go about doing
this?

Do I need a key somewhere.. like... do I need to highlight some cells
somewhere with the colors that were used... .and then put numbers next to
them in the column next to those colors which will give the value that I
want returned?
Or, are there already pre-set values based on the colors, and I just need
to say if cell.backgroundcolor is AABBFF, then value.of.current.cell=1

Hope this makes sense!

Dexter