I have 4 cells in a work sheet that I have to type or copy information into.
This cell always has more than 250 characters. What I wanted to do was set
up a conditional formatting statement that will turn all text greater than
250 characters red. The cell will allow you to type in and exceed the 250
characters. I can set up a validation to tell me when It exceeds the 250
characters? or, is there a way to stop the data entry at 250 characters per
cell?
Another option I have thought about but do not know if it will work in excel
2007. is after 200 characters it pushes the remianing text to the cell below
it. I am taking suggestions to address this issue.