Hi, Frank:

What about the "Shrink to Fit" option under Format/Cells/Alignment? For me it
does just what the OP is talking about....

Myrna Larson

On Tue, 14 Dec 2004 18:11:45 +0100, "Frank Kabel"
wrote:

Hi
only possible with VBA. You may download the following addin for this
extension of the conditional format (as Excel's build in format can't change
the font size):
http://www.xldynamic.com/source/xld.....Download.html

Within this addin you could specify a condition based on the length of your
cell value. e.g.
=LEN(A1)10
and then choose a smaller font size