I've attached a zip with an Excel file. The guy who made it is no longe
present in the company and to be honest, I have no idea how he did wha
he did.

This excel sheet is used for import. On the right side there's a lis
of valid products with the code. On the import sheet a lot of rows ar
filled out.... the articlecode (artikelcode) which is filled out i
instantly verified against the data on the right... so if someone fill
out the sheet with data and makes a mistake it will display in red. Fil
out code "1232" for example on a row in "artikelcode" and press enter
It'll turn red.

I know how the data on the right side is added to the Excel sheet an
refreshed, but what I do not understand is..... HOW does the validatio
take place? I can't find any macro whatsoever which turns a field in th
column "artikelcode" red as soon as an invalid code is entered (whic
cannot be found on the right).

Could somebody please explain me? :confused

+-------------------------------------------------------------------
|Filename: lava_sdrerxbvs.zip
|Download: http://www.excelforum.com/attachment.php?postid=3904
+-------------------------------------------------------------------

--
Lav
-----------------------------------------------------------------------
Lava's Profile: http://www.excelforum.com/member.php...fo&userid=2779
View this thread: http://www.excelforum.com/showthread.php?threadid=47539

Your predecessor used "Conditional Formatting" (FormatConditiona
Formatting... on the main menu) to test the contents of the cells i
column E as such:

=AND(COUNTIF($J$2:$J$3004,E17)=0,NOT(ISBLANK(E17)) )

Which says if the value entered in E17 is not found in column J, tur
the cell RED. The NOT part prevents Blank cells from being turne
RED.

Pretty slick and works well for this task.

HT

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47539