Conditional formating 1

[coltaalex]

I have two columns, with text codes,
the codes in in the first column are not changing,
in the second column value are permanent changing,
so i need to use conditional formatting to do : when introducing values in the second column and these values don't exist in the first column, to make these cells ( in the second column) red

 

[electricpete]

Let's say your first column is D1013 and 2nd column is E10:E13

For cell E10, apply formatting as follows:
Format / ConditionalFormatting / FormulaIs...
=ISNA(MATCH(E10,$D$10:$D$13,0))
And select format like red
Press ok

Use format painter to copy the format into remainder of the cells in column E

 

[coltaalex]

now how to make a message bob to appear when i have red cells

 

[coltaalex]

i tried this :

Sub color2()
Dim N As Long
For N = 1 To 56
If Cells(N, 8).Interior.ColorIndex = 3 Then
MsgBox "Codes don't Exist "
Exit For
Else

End If
Next N
end sub


it's not working with conditional formatting

 

[SkipVought]

Hi,

This can be done with native Excel Conditionla Formatting. You do not need VBA code, just a formula in the CF.

You can get the COUNT of those that do not exist also using a COUNTIF function.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[coltaalex]

hi Skip how about the message box, when the conditional formula is true

 

[SkipVought]

How incredibly dumb! Why not a value in a cell? I get extremely annoyed clicking message buttons, when other less intrusive methods exist!!!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[coltaalex]

sorry Skip i didn't understand your last message,
my first language is not English