Hi,

I'm playing with the Conditional Formatting of a cell. I need to change the
font according to the value of the cell. The problem is the font selector is
disabled on the conditional format dialog. Is not possible to change the
font when conditional formatting the cell or may be I'm missing something?

Thanks in advance

--
Faustino Dina
--------------------------------------------------------
If my email address starts with two 'f'
drop the first 'f' when mailing me.

No. You'd need to run a macro for that.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com


"faustino Dina" wrote in message
...
Hi,

I'm playing with the Conditional Formatting of a cell. I need to change
the
font according to the value of the cell. The problem is the font selector
is
disabled on the conditional format dialog. Is not possible to change the
font when conditional formatting the cell or may be I'm missing something?

Thanks in advance

--
Faustino Dina
--------------------------------------------------------
If my email address starts with two 'f'
drop the first 'f' when mailing me.

Hi
Conditional format does not support changing the font type. If you need
this youll have to use VBA (processing the worksheet_change event).
e.g.the following code checks column A for a specific value (put this
in your worksheet module):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub
On Error GoTo CleanUp:
With Target
If .Value = 1 Then
.Font.Name = "Arabic Transparent" 'change this
font name
End If
End With
CleanUp:
Application.EnableEvents = True
End Sub




--
Regards
Frank Kabel
Frankfurt, Germany

faustino Dina wrote:
Hi,

I'm playing with the Conditional Formatting of a cell. I need to
change the font according to the value of the cell. The problem is
the font selector is disabled on the conditional format dialog. Is
not possible to change the font when conditional formatting the cell
or may be I'm missing something?

Thanks in advance

That is correct. My take is that Conditional formatting does not support
changing anything that might change the overall format of the worksheet.
Changing the font could result in data being cut off unless the column is
made wider because the characters in the font might require more space (as
an example). Thus size is not an option either.

--
Regards,
Tom Ogilvy

"faustino Dina" wrote in message
...
Hi,

I'm playing with the Conditional Formatting of a cell. I need to change
the
font according to the value of the cell. The problem is the font selector
is
disabled on the conditional format dialog. Is not possible to change the
font when conditional formatting the cell or may be I'm missing something?

Thanks in advance

--
Faustino Dina
--------------------------------------------------------
If my email address starts with two 'f'
drop the first 'f' when mailing me.