Is there a way for a cell to be conditionally formatted to show that it is
going to exceed a specific number of characters? For example, the
information is already in the spreadsheet. I would like cells in Column B to
show the text in red, bolded if the cell exceeds 30 characters/spaces. As
far as I can see, data validation does not work because that only brings up
flags as data is entered. Also, I do not want to just limit the text as
these are proper names and addresses so appropriate abbreviations will need
to be made.

I hope this is clear and appreciate suggestions from all. Thanks.