If And Conditional Formatting

[honeybeebzz]

Hello,

I am wondering if anyone can help me. I currently have a Conditional Formatting set up to highlight a cell if it is a duplicate. Is it possible to highlight a cell if it's duplicate and another cell contains specific text. In my spreadsheet, there is a name in column D that I want highlighted but only if column Q shows the word "open". I might have the name listed in the spreadsheet elsewhere but it has already been worked and therefore shows "closed" in column Q.

Thank you.

 

[Joe4]

Welcome to the Board!

In my spreadsheet, there is a name in column D that I want highlighted but only if column Q shows the word "open".

Does it need to be on the same row?

It might actually be best to post a small sample of your data, and show us what you want the end result to look like.
While you cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Scott T]

Assuming you ant the open to be on the same row

In conditional formatting try
adjust ranges as need

=AND(SUMPRODUCT(--($D$2:$D$18=D2))>1,(Q2="open"))