I'm not clear as to what you are trying to do.
1/. By using Data Validation you can prevent the user entering CHAR(10) more than once in any cell. CHAR(10) is alt+Enter in Excel
Select say A1 then > Data Validation
Allow:= Custom
Formula:
2/. With Format > Cells > Number > Custom
Type:
If you now type "One hundred fifty* in A1 it will display as "One hundred fifty______[/U]only", the number of underscores is determined by the cell width.
You can't make this part "only", red and the rest black using Custom format.
Bookmarks