I have an Excel workbook with two sheets. On the 1st sheet, I have several columns of information about departments participating in a certain program, including names and email addresses. On the 2nd sheet, I have several columns of information regarding correspondence with the departments, including names and email addresses. I would like to create a conditional format in the cells of one column of sheet 2. Either the column containing the names or email addresses, but preferably the email addresses. I would like to have the formula look at the email address in the cell and find it in the range on the 1st sheet then, if it is not there, format the cell to fill with a certain color. Basically I would like to say, "if this email is not on the first sheet, fill in with yellow". It looks like I can’t do this because: "You cannot use references to other worksheets or workbooks for Conditional Formatting criteria." So, if it can’t be a conditional format, I would like to create a column in sheet 2 just to tell me if there is a match. I would like the formula to look in a cell on sheet 2 and find the same email address in a certain column on sheet one & return a "no", if there isn't one, or a “yes” if there is one, or something that would tell me one way of the other. Is this possible? If so, what is the formula I would use?

Office Software forum. This isn't an xp issue.

What? I don't understand what you're saying.

Okay, I found forums, and I found software forum. I tried to post thisd question there and I get a message that I'm not allowed to ask questions in 2 forums. I can't find a way to delete this one. is there a way?

Next time ask an Excel question in the Office Software forum. Try rephrasing the question.

Well, I'm trying to do that now, but it won't let me because I asked it here already! Is there a way to delete this??? This is the first time I've been to this site and I simply entered the question in the space that said "ask a question". Now I understand where to ask, but I can't.

A moderator should be along some time soon to delete this thread.