M Michael Kintner Jan 6, 2004 #1 How do I set the background color of a cell to red or black? Thank you for your help in advance!!! (smile) Mike
How do I set the background color of a cell to red or black? Thank you for your help in advance!!! (smile) Mike
J John Wilson Jan 6, 2004 #2 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
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
B Bob Phillips Jan 6, 2004 #3 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)
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)
