Help - Conditional Formatting change font size

[Khalid NGO]

Hello experts,

Is there any way to change the font or font size in conditional formatting?

Thanking you in anticipation,
Khalid.

 

[vijay.vizzu]

Yes.. you can achieve this by conditional formatting, just click format button while applying formula.. in that click Font tab on the above.. and select bold option and other options also

 

[Hui]

 

[Khalid NGO]

Thanks Sir Hui and Vijay,

Actually the "Font" and "Size" options are disable.
Suppose i need Red color and Difference Font + Small Size for the units below 500.

 

[Hui]

Khalid
Actually you can't change the Font or Size in CF
Because changing those would potentially change the Column Width and other issues on the worksheet
CF is designed to change the Visibility of the cell, not it's inherent properties like cell size.

It could be done with VBA if really required.

 

[Khalid NGO]

Oh i see,
it was not in my knowledge...

VBA not necessary, i will manage with colors.
Many thanks Sir Hui

 

[Hui]

The following VBA Code will do what you want

Add it to the Worksheet Module in VBA

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Range("D3:D18")) Is Nothing Then
  If Target.Value <= 500 Then
  With Target.Font
  .Color = -16776961
  .Name = "Arial Narrow"
  .Size = 8
  End With
  Else
  With Target.Font
  .Color = -16250872
  .Name = "Calibri"
  .Size = 12
  End With
  End If
End If
End Sub

see attached:

 

[Khalid NGO]

Wow its working Hui, excellent....

I just want to say you are a genius man with big heart who always ready to help others.
God bless you.

 

[Hui]

Obviously change the fonts, sizes and colors to suit

 

[Khalid NGO]

Yes i am playing with your code.
Many Thanks Sir Hui.