Sub justtest()<br/> Dim dic, i&, rng1 As Range, rng2 As Range<br/> Set dic = CreateObject("scripting.dictionary")<br/> For i = 1 To Cells(Rows.Count, 1).End(3).Row<br/> dic(Cells(i, 1).Value) = ""<br/> Next<br/> Set rng1 = [d3:k15]<br/> rng1.Interior.ColorIndex = xlNone<br/> For Each rng2 In rng1<br/> If Not dic.exists(rng2.Value) And rng2 <> "" Then<br/> rng2.Interior.ColorIndex = 12<br/> End If<br/> Next<br/> Set dic = Nothing<br/>End Sub<br/>
Sub justtest()<br/> Dim dic, i&, rng1 As Range, rng2 As Range<br/> Set dic = CreateObject("scripting.dictionary")<br/> For i = 1 To Cells(Rows.Count, 1).End(3).Row<br/> dic(Cells(i, 1).Value) = ""<br/> Next<br/> Set rng1 = [d3:k15]<br/> rng1.Interior.ColorIndex = xlNone<br/> For Each rng2 In rng1<br/> If Not dic.exists(rng2.Value) And rng2 <> "" Then<br/> rng2.Interior.ColorIndex = 12<br/> End If<br/> Next<br/> Set dic = Nothing<br/>End Sub<br/>
Sub justtest() Dim rng1 As Range Dim rng2 As Range Dim rng3 As Range Set rng2 = Range("d3:k15") Set rng3 = Range("a1:a" & Cells(1, 1).End(4).Row) rng2.Interior.ColorIndex = xlNone For Each rng1 In rng2 If rng1 <> "" Then If rng3.Find(rng1) Is Nothing Then rng1.Interior.ColorIndex = 21 End If End If Next End Sub