Hi,

I am working with a document that has a column that can only be 40 characters max when I upload it to the web. I would like to set it up so those cells highlight when it has more than 40 characters in it. I am constantly adding new items that come through and if it's greater than 40 characters, I'll need to manually revise them. So I'm not looking for something that will only allow 40 or cuts off after 40. I just want to be "notified" that it's too long.

As far as I can tell, conditional formatting is only based on the value of the cell - please give me any insight to this.

Thanks!