Data Validation Question

[MichaelRSnow]

Hi There<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Anyone know if you can put data validation based on value of cell not formula lenght?<o></o>
<o></o>
i.e.<o></o>
<o></o>
Cell A1 has the following formula =AA1&"%" & " 2Yr Fix"<o></o>
<o></o>
Result of formula is [4.99% 2Y Fix]<o></o>
<o></o>
Data validation should read 12 characters (including spaces) and not 20 characters which is the text length of the formula?

any ideas?

 

[JackDanIce]

I think this may work. In Data Validation, select "Custom" (under Allow) and your formula is

Len(A1)<=12

 

[GlennUK]

Your formula and your text don't match. One is 12 characters the other is 13. Cell Validation works on the cell value, not the formula length.

4.99% 2Yr Fix
is the 13 char one.

 

[MichaelRSnow]

Cheers Jack, works perfectly

 

[JackDanIce]

You're welcome