Did you color them via Format|Cells or Format|Conditional formatting.

If the first, then visit Chip Pearson's site and see how you can use a
UserDefined function return the color of a cell.

http://www.cpearson.com/excel/colors.htm

If the color of the cell is from format|conditional formatting, I think I'd just
use the same rules in another cell (a nice formula) to determine what color the
cell should be.

But if you want to try some VBA (not for the faint of heart), Chip has some
code:
http://www.cpearson.com/excel/CFColors.htm

Connie Martin wrote:

I have a huge spreadsheet of data. Certain cells are coloured yellow. What
I would like is a formula that I can enter in all the cells of the column
that would say: "If this particular cell is coloured yellow then it should
equal O43, otherwise it's to be left blank."

Thank you
Connie

--

Dave Peterson