Can you change fonts within the formula's of a cell. If so how???

Cannot be done.

Copy and Paste as value then you can change the font.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 11:38:04 -0700, cody wrote:

Can you change fonts within the formula's of a cell. If so how???

no
you can change fonts in a text only cell
but not with a formula

"cody" wrote:

Can you change fonts within the formula's of a cell. If so how???

Hi,

No.

You can change format of a cell for display purpose. Formulas are stored
values, therefore assingning any font color to the formulas does not make
sense.

Note: You cannot change fonts for Named formula.

Challa Prabhu

"cody" wrote:

Can you change fonts within the formula's of a cell. If so how???

Depending on exactly what you are trying to do, this may be something you
might be interested in playing with......

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Cell font type, size, and color depends on cell value
'Also works on formula results
If IsNumeric(Selection.Value) And Selection.Value < "" Then
Select Case Selection.Value
Case 0 To 9
Selection.Font.Name = "script"
Selection.Font.ColorIndex = 3
Selection.Font.Size = 10
Case 10 To 20
Selection.Font.Name = "ariel"
Selection.Font.ColorIndex = 5
Selection.Font.Size = 12
Case Is 20
Selection.Font.Name = "times new roman"
Selection.Font.ColorIndex = 8
Selection.Font.Size = 14
Case Else
GoTo 100
End Select
100
End If
End Sub

hth
Vaya con Dios,
Chuck, CABGx3




"cody" wrote:

Can you change fonts within the formula's of a cell. If so how???