Changing Cell Backround from Marco

[davep1553]

I need to know the command(s) to change the backround color of a cell
from a VBA marco.



Not Important but I feel like typing
I'm writing code into the change event of a spreed sheet to automaticly
compare a few dates refer to when things have happened and if they get
too far off make a cell red so it's clear I should get the info to
update this.

 

[Gary Keramidas]

this would make a1 light blue

Sub test()
Range("a1").Interior.ColorIndex = 37

End Sub