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?