Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color of Cell Background
How do I set the background color of a cell to red or black?
Thank you for your help in advance!!! (smile) Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color of Cell Background
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color of Cell Background
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Background Color | Excel Worksheet Functions | |||
cell background color and cell text color | Excel Worksheet Functions | |||
How do I- IF the cell background is RED in color then contain 1 | Excel Worksheet Functions | |||
Add background color to cell | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |