ExcelBanter - IF Statement based on cell color

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Statement based on cell color (https://www.excelbanter.com/excel-worksheet-functions/189482-if-statement-based-cell-color.html)

Koshkii

IF Statement based on cell color

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

IF Statement based on cell color

See:

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

--
Gary''s Student - gsnu200789

"Koshkii" wrote:

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

Koshkii

IF Statement based on cell color

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

"Gary''s Student" wrote:

See:

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

--
Gary''s Student - gsnu200789

"Koshkii" wrote:

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

All times are GMT +1. The time now is 03:39 PM.