Color of Cell Background

[Michael Kintner]

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

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

Mike

 

[John Wilson]

Michael,

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

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

John

 

[Bob Phillips]

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)