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