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