You don't need the IF(...,TRUE,FALSE) , Frank.

Instead of
=if(K1P1,True,False)
you can use
=K1P1
as that will return a Boolean result.
--
David Biddulph

"Frank Pytel" wrote in message
...
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