Excel formula on cell for valid password-CodePudding

I'm creating a template for importing users in bulk to the system, one of the columns requires to input password,

I would like to create a condition on the [password] cell, in order to indicate to the person that input the details that the password is valid

those are the conditions:

Password must contain at least

6 characters

1 symbol

1 number

1 letter

This is what I tried : MEDIAN(6) AND (OR),EXACT(LOWER()))) but no luck. all the symbols are valid but the values of the characters must be in English

is it possible?

CodePudding user response：

A password-validator immediately screamed 'regular-expressions'. Will you want to go down the path of VBA, you'd require the following pattern:

^(?=.*?[!#$])(?=.*?[A-Za-z])(?=.*?\d).{6,}$

See an online

and(len(A1)>=6,MAX(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1,1),"")))

is the formula used in the data validation. Youi can see that A1 meets the length >=6 but I have not controlled that the count of numbers, hiowever you can add that.