custom data validation
"Frank Pytel" wrote:
Gareth;
Have you considered Conditional Formatting. This will not prevent the user
from entering information, but the code is a little lighter on your
application. Select the Colum P cell(s) that you want alerted and Go To:
Format Conditional Formatting.
From the drop down menu select Formula and enter the following code:
=if(K1P1,True,False)
Click on the Format button and choose what you want to happen when this is
true. The formula says that if the Start Date comes before the End Date,
turn the "cell Red", "Font Green/Bold" or whatever else you desire.
God Bless
Frank Pytel
Frank
I do need to use data validation as cond formatting will let users enter the
incorrect date even though they have been warned about it.
Gareth
|