Highlighting cells based on them matching another list of values

[david1987]

Hi,

I have a list of account numbers in one column, next to this column I have a number of units sold for that customer, this updates automatically and introduces new customers as units are sold.

I have another list that is a list of account numbers that have been sent marketing information. I want to highlight in red the account numbers that have received the marketing letter while leaving others blank.

Below is an example of this.


Account Number Units Sold
A0010 24
A0020 69
A0030 25
A0040 12




Marketing Letter Received By

A0020
A0030

I would like to highlight accounts A0020 and A0030 in red....

Any help would be appreciated

Thanks

David

[Fotis1991]

UNTESTED

In conditional formatting rules in range a1:a100, put this formula.

=COUNTIF($C$1:$C$100,$A1)>0

c1:c100=Marketing Letter Received By

[dilipandey]

Hi David,

Try using below formula in conditional formatting :

Please Login or Register  to view this content.

where H column has the accounts which received marketing letter.

See attached:- conditional formatting.xlsx


Regards,
DILIPandey

<click on below 'star' if this helps>