Auto Font Substitution

[EdWoods]

Hi,

I have a workbook that has a column for comments alongside the entry.

Sometimes comments run longer than the size of the cell. I know you can Shrink to Fit, however what I would prefer to do is substitute the font - my main font is Arial and if the cell contents are too large, I'd like it to auto change it to Arial Narrow (just for that cell, not all the cells in the column).

Possible or not possible? If it is possible, I imagine it would be somehow through Conditional Formatting. I just have no idea how.

Cheers, Paul.

[FDibbins]

You could maybe use CF if you know how many characters the cell can take, but perhaps another option would be to use Wrap Text for those cells? As you type, the row will increase in height to wrap the text top the next line (not next row)