How do I set the background color of a cell to red or black?

Thank you for your help in advance!!! (smile)

Mike

Michael,

range("a4").interior.colorindex = 1
for black (3 for red).

For a lot more on colors, take a look he
http://www.mvps.org/dmcritchie/excel/colors.htm

John

"Michael Kintner" wrote in message
...
How do I set the background color of a cell to red or black?

Thank you for your help in advance!!! (smile)

Mike

Goto the Format menu, select Cells, and then the Patterns tab. Select your
colour from there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michael Kintner" wrote in message
...
How do I set the background color of a cell to red or black?

Thank you for your help in advance!!! (smile)

Mike