IF Statement based on cell color

[Koshkii]

Hi there,
I have a question that seems to be the reverse of the others i'm seeing
here. I don't want to do conditional formatting. I have an exported Excel
table that already has colors assigned to different cells. I want to create
an IF statement that says: =IF(A1 is Red), then return text in A1, else
blank.

In the end, I'd like to generate a column with all of the text (e-mail
addresses) from the red cells that I can concatenate into a list of e-mail
addresses that are easy to copy/paste into a mail.

Anyone have any ideas? Thanks! Heather

 

[Gary''s Student]

See:

http://www.cpearson.com/excel/Colors.aspx

 

[Koshkii]

Thanks! It's beyond my skill level, but maybe now's the time to learn VBA