I've got a column where the entries are checked against all fields of
column on another worksheet. If there's no match the entry is invali
and colored red. This is accomplished by means of Conditiona
Formatting:


Code
-------------------
=EN(AANTAL.ALS(Referentie_Lijst;C5)=0;NIET(ISLEEG( C5))
-------------------


I've also written a macro which does the checking, but for ALL entr
fields of that column; not just the one which was just entered. Th
reason for this was that I did some testing with the sheet. At som
point I had so many test values that I simply selected them all an
pressed [del]. To my surprise the Conditional Formatting for the field
of that particular column was deleted as well.

Is there a real problem as I got a macro which takes care of things a
the end by checking them all by means of a button? Well, the people wh
will be using the sheet for entry wish for the immediate check pe
entry.

Is there a way by means of a macro or so to ensure that the Conditiona
Formatting is "re-applied" or something in case it gets deleted? O
should I resort to an all-macro solution? An all-macro solution woul
be possible to make, but I just want to know if the Conditiona
Formatting for a column can be locked or reapplied somehow

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