PDA

View Full Version : Data Input Restrictions



mostwantedki
12-09-2010, 09:22 AM
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
12-09-2010, 09:34 AM
Look at Data Validation.

mostwantedki
12-09-2010, 09:40 AM
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
12-09-2010, 12:00 PM
DV has a Text Length type, you can use that.

mostwantedki
12-10-2010, 01:24 AM
can any body help on this.. still iam unable to do this.

mostwantedki
12-10-2010, 01:32 AM
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
12-10-2010, 01:54 AM
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
12-10-2010, 03:25 PM
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!