Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
specify cell selection in a marco | Excel Discussion (Misc queries) | |||
backround text | Excel Discussion (Misc queries) | |||
How can you add a picture as a backround? | Excel Discussion (Misc queries) | |||
Printing a Backround | Excel Discussion (Misc queries) | |||
Trying to *simply* programmicly get a bmp file to be the plotarea backround | Excel Programming |