Hi all,

Is there a way to prevent a person from typing past a character limit?

I know that in Data Validation you can set a character limit for the cell, but that doesn't prevent them from typing more than the limit, it just prevents the text from being accepted once they hit enter.
Is there a way to limit the cell input so that once they reach say 140 characters whatever they continue typing doesn't appear?

Or, perhaps once they reach 140 characters the cell/text color changes to red?