VBA Query???

[Abhishek Ghai]

Please help me with a VBA code where only those cells should be colored where there is a value. I tried the same but was only able to get the cells colored by the range...(below code)

Sub Colo()
Range("A1:A13").Interior.Color = RGB(255, 0, 0)
End Sub


Regards

Abhishek.

 

[sadath]

Sub Colo()
for each cl in Range("A1:A13")
if cl<>"" then cl.Interior.Color = RGB(255, 0, 0)
next cl
End Sub

 

[Abhishek Ghai]

I tried the cod but it is giving me a compile error - Variable Not Defined....