Changing Cell Backround from Marco
 

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.


--
davep1553
------------------------------------------------------------------------
davep1553's Profile: http://www.excelforum.com/member.php...o&userid=28517
View this thread: http://www.excelforum.com/showthread...hreadid=503751

Changing Cell Backround from Marco
 

this would make a1 light blue

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

End Sub

--


Gary


"davep1553" wrote
in message ...

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.


--
davep1553
------------------------------------------------------------------------
davep1553's Profile:
http://www.excelforum.com/member.php...o&userid=28517
View this thread: http://www.excelforum.com/showthread...hreadid=503751