Here's an example of how this is possible. In B1, I have this
formula:

=LEN(A1)<=15

In A1, I have this custom validation rule:

=B1

If the input is more than 15 characters, user will get an error
message.

However, you must have calculations on automatic for this to function.



On Dec 19, 3:47 am, Anders wrote:
Hi,

How can i get excel to show requirement for validation?

For example I want people to type in a text max 15 characters, but I want
them to be able to see how many characters they can type. For example the
cell can show XXXXXXXXXXXXXXX and as they start filling it in they swap the X
for their own words.

I know I can do validation max 15 character length but then they get a error
box and need to keep taking away characters untill they get below 15. Its
better if they can see it straight away, how many to fill inn.

--
Regards Anders