JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
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
=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