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.