Conditional Formatting with Arrays

[carlsondaniel]

Hi, I have a question regarding arrays and conditional formatting. I
have two columns. One is my master list which contains the numbers that
I need. The other column has numbers that may or may not be inclunded
in the Master list. Is there a way I can create a new column that would
return the number in Column B the color black if it is in the master
list and red if it isn't? Below is an example:

Thank you for your assistance!


Master List Column (A) Column with Potential Difference (B) Return
(C)

100001 100001 100001
100002 111000 111000 (in red)
100003 111000 111000 (in red)
100004 111000 111000 (in red)
100005 100004 100004
100006 112000 112000(in red)
112000 112000 (in red)
100005 100005

 

[Max]

Source range assumed in A2:A7, range to be compared & CF'd in B2:B9

Select B2:B9 (with B2 active), apply the cond format formula:
=ISNA(MATCH(B2,$A$2:$A$7,0))
Format the font to red/bold

Pl follow up here in the thread ..

 

[Max]

Here's a quick sample (with CF dialog screenshot) for easy ref:
http://cjoint.com/?jpdEGibOvL
Carl_CF.xls