Data Input Restrictions

[mostwantedki]

Hi All,

It is possible to restrict each cell only having 40 charcters to enter in Excel.

Please help on this.

very new to this area.

[Bob Phillips]

Look at Data Validation.

[mostwantedki]

Hi i guess i tried one of your solution but no luck ...
=AND(ISNUMBER(E1),LEN(E1)=10)

iam very new to this even dont know how use this..

i tried Use Data>Validation with a type of Custom, and a formula of
and press ok still able to enter 13 charter in a column.

[Bob Phillips]

DV has a Text Length type, you can use that.

[mostwantedki]

can any body help on this.. still iam unable to do this.

[mostwantedki]

Hi My requirement was .. data validation needs to be check in all the cells should have only 40 charcters if it is more than 40 charcters it should shown as a different colour in the cell... please help on this.

[mostwantedki]

i was trying to validate an existing excel it has each cell has more then 40 charcters and i need to validate this for 40 charcters then the other charcters need to show as a different color.

[austenr]

Data -> Validation -> Text Length -> Less Than or Equal To -> 40

Then either copy that down using paste special or use the format painter, your choice

or using Conditional Formatting

Select A1:A100 range and enter =LEN(A1)>15 in CF formula field and select a background color!