How to colour cells based on variable

Hello All,

I have just started with VBA and am having trouble with a basic problem of formatting a cells appearance based upon the value of a cell. For example I have the number 1 to 10 in a list and would like to format individual cells yellow if they have the value 5 and above, Once I have the VBA code basics I should be able to apply this to numerous sheets.

Any help would be much appreciated.

Jaso

Thanks for getting back to me protonLeah. I've already tried playing around with the macro recorder however I'm not to sure how to get it to pick up "if" statements. This is what I have so far. I'm pretty sure the problem is I have the syntac all wrong... Any suggestions? (Note: I have number 1 to 10 in order in cells A1 to A10).

Sub Using_If()
If Range("A1:A10").Value >= 5 Then
Range("A1:A10").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If

End Sub