Highlighting Cells

[Najwan]

VBA to highlight the cell if value is exceeding a certain number

 

[MARK858]

Welcome to the forum, why do you need VBA for this? it is much easier with conditional formatting.

Either way to answer your question preferably we would like a screenshot (click on XL2BB in my signature block to see the preferred method for doing this), and definitely need to know what the range and the number are.

 

[Skyybot]

Sub HighlightCell()
Dim cell As Range, aNumber As Integer
aNumber = 5
Set cell = Selection
If Selection.Count > 1 Then Exit Sub
If Selection.Value > aNumber Then Selection.Interior.Color = vbYellow
End Sub