Hi Myrny
how embarrasing :-)
Never used this feature before <vbg

--
Regards
Frank Kabel
Frankfurt, Germany

Myrna Larson wrote:
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