Changing fonts with a formula
On Thu, 22 Apr 2010 02:38:23 -0600, "Blue Max" wrote:
Is there any way to change the font of a cell using conditional formats or a
formula that will specify the font?
It appears that conditional formats cannot be used to change the cell font
in Excel 2007. Is this correct? If not, is there a function similar to the
TEXT() function that would allow a user to insert text in a cell in a
specific font and size?
You can not change fonts with a formula. Functions can only return a value.
Conditional formatting will not change the font family, although it can change
certain attributes of the font (e.g. bold, italic, etc).
You can change the font family using a VBA macro; testing within the macro for
certain conditions so it works similar to conditional formatting. Is that what
you want? If so, provide more information.
--ron
|