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:

=(MINUSCULE(GAUCHE(B2;4))="http")

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

=(MINUSCULE(GAUCHE(B:B;4))="http")

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.