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