Function to valid a column start with "http"

Hi,

I'm looking for a way to validate if the input start with "http".

I have a formula in my validation field that look like this:

Please Login or Register  to view this content.

It's okay for the cell B2... but I need that validation to apply on all the colum. I tried:

Please Login or Register  to view this content.

But I keep getting an error EVERY time, even if it's valid.

Thanks.

jonat

Edit: As you can see my excel is'nt in english... in english, "minuscule" should be something like "lowercase" and "gauche" mean "left"

The validation doesn't work that way....

to apply the validation to the entire column, copy the one that works from B2,

then select the entire column and go to Edit|Paste Special and select Validation.

Click Ok...

Now the validation should be applied to the whole column.