Hi all,
I have this vba to change the font size based on cell value, but I need the font size to change if the cell contains "Writing" (there will be other words before and after), how do I do this?
Kind Regards
Luke
Private Sub UpdateFontSize()
Dim rng As Range
Dim rCell As Range
Set rng = Range("AD10:AF10")
For Each rCell In rng
If Len(rCell.Text) > 2 Or _
Val(rCell.Value) > 10 Then
rCell.Font.Name = "Century Gothic"
rCell.Font.Size = 9
Else
rCell.Font.Name = "Century Gothic"
rCell.Font.Size = 11
End If
Next
End Sub
Bookmarks