MATCH in Conditional Formatting

[JTL9161]

I have the following formula in Conditional Formatting
=MATCH($D2,LIST,0)
If anything in column D matches any of the data in LIST column its to highlight it, but if it does not match the LIST the data in D2 is cleared with a "" in a IF(LOOKUP) formula.
The cell highlights when it matches but when the cell is blank it still highlights.

How can I write the formula so to highlight when it matches the LIST but when its blank (and does not match on LIST) is does not highlight?

Thanks,
James

 

[Joe4]

How about:

=AND(MATCH($D2,LIST,0),$D2<>"")

or

=COUNTIF(LIST,$D2)>0

Also, make sure that there are not any "blanks" in your LIST.

 

[JTL9161]

How about:

=AND(MATCH($D2,LIST,0),$D2<>"")

or

=COUNTIF(LIST,$D2)>0

Also, make sure that there are not any "blanks" in your LIST.

The list is about 30 rows down and data is filled in over time so there could be 1 cell with data and 29 blanks. Eventually all will be filled but not right away.

 

[Joe4]

The list is about 30 rows down and data is filled in over time so there could be 1 cell with data and 29 blanks. Eventually all will be filled but not right away.

OK, then I think either of these formulas should work:

=AND(MATCH($D2,LIST,0),$D2<>"")

or

=AND(COUNTIF(LIST,$D2)>0,$D2<>"")

 

[JTL9161]

Thank you. it worked

 

[Joe4]

You are welcome.
Glad I was able to help!