Hi, I'm having a little problem defining ranges. I want to have one cell Bold and Red, while the other cells are normal font.
With Range("C22")
.Font.ColorIndex = 3
.Font.Bold = True
End With
With Range("C20:C21", "C23:C26")
.Font.ColorIndex = 1
.Font.Bold = False
End With
When I run this, all the cells are normal font
Any help appreciated
Thanks
With Range("C22")
.Font.ColorIndex = 3
.Font.Bold = True
End With
With Range("C20:C21", "C23:C26")
.Font.ColorIndex = 1
.Font.Bold = False
End With
When I run this, all the cells are normal font
Any help appreciated
Thanks