Conditional Formatting when text overflows the cell

[quackdad]

Is it possible to conditional format a cell when it contains more content than can be displayed? I have created a message box to show the full contents when they click on the cell, but I also want to alert a viewer that there is more in the cell than what they are seeing (e.g., change the font to italic). I do not want to change the width of the column or the height of the row, and I do not want to shrink the text to fit.

 

[dave3009]

Hi

One method might be to find out how many characters will actually go in the cell, for example - in my workbook a standard cell with font Calibri at size 11 will hold six characters so I set a conditional format to be formula is: =LEN(A1)>6, the caveat here is that if the user enters a lot of narrow characters such as I then it may look a little out of sorts but it's one quick fix.

HTH


Dave

 

[quackdad]

Thanks, Dave. It should work for my purposes. I suppose I could change the font to something like Courier if I wanted to be anal about it (and didn't care how it looked.….).