| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set background color of a cell in VBA
Anyone know how to change the background color of a cell
in Excel 2000 VBA code? Thank you Cindy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
I suggest the best method would be to record a macro of the chang
required -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
activecell.Interior.ColorIndex = 3
-- Regards, Tom Ogilvy "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
Cindy,
Try something like the following. Range("A1").Interior.ColorIndex = 6 'yellow -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
Thanks to all that replied. It works.
Maybe you can help futher. What I need to do is check 8 specific cells on a sheet to be sure they contain a value before the user can continue. My idea is to change the color of those cells that are empty - which works. But now I'm trying to figure out the best way to recheck the cells and reset the color to white, where I might need to do this several times, depending if the user actually entered data in all 8 cells. Right now I'm using 8 separate If statements to check the cells for values. Thanks Cindy -----Original Message----- Cindy, Try something like the following. Range("A1").Interior.ColorIndex = 6 'yellow -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
Cindy,
You might want to use the Conditional Formatting tool on the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Thanks to all that replied. It works. Maybe you can help futher. What I need to do is check 8 specific cells on a sheet to be sure they contain a value before the user can continue. My idea is to change the color of those cells that are empty - which works. But now I'm trying to figure out the best way to recheck the cells and reset the color to white, where I might need to do this several times, depending if the user actually entered data in all 8 cells. Right now I'm using 8 separate If statements to check the cells for values. Thanks Cindy -----Original Message----- Cindy, Try something like the following. Range("A1").Interior.ColorIndex = 6 'yellow -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
That was one of my first thoughts but there is no criteria
for a "null" cell. -----Original Message----- Cindy, You might want to use the Conditional Formatting tool on the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Thanks to all that replied. It works. Maybe you can help futher. What I need to do is check 8 specific cells on a sheet to be sure they contain a value before the user can continue. My idea is to change the color of those cells that are empty - which works. But now I'm trying to figure out the best way to recheck the cells and reset the color to white, where I might need to do this several times, depending if the user actually entered data in all 8 cells. Right now I'm using 8 separate If statements to check the cells for values. Thanks Cindy -----Original Message----- Cindy, Try something like the following. Range("A1").Interior.ColorIndex = 6 'yellow -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy . . |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
Cindy,
You can use conditional formatting. In the CF dialog, change "Cell Value Is" to "Formula Is" and enter the formula =LEN(A1)=0 where A1 is the appropriate cell reference. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... That was one of my first thoughts but there is no criteria for a "null" cell. -----Original Message----- Cindy, You might want to use the Conditional Formatting tool on the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Thanks to all that replied. It works. Maybe you can help futher. What I need to do is check 8 specific cells on a sheet to be sure they contain a value before the user can continue. My idea is to change the color of those cells that are empty - which works. But now I'm trying to figure out the best way to recheck the cells and reset the color to white, where I might need to do this several times, depending if the user actually entered data in all 8 cells. Right now I'm using 8 separate If statements to check the cells for values. Thanks Cindy -----Original Message----- Cindy, Try something like the following. Range("A1").Interior.ColorIndex = 6 'yellow -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy . . |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
The null condition is the starting condition. So the cell can be
yellow when there is nothing in it, and then the Conditional Formatting would be white if the cell value is not blank (or vice versa). "Cindy" wrote in message ... That was one of my first thoughts but there is no criteria for a "null" cell. -----Original Message----- Cindy, You might want to use the Conditional Formatting tool on the Format menu to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Thanks to all that replied. It works. Maybe you can help futher. What I need to do is check 8 specific cells on a sheet to be sure they contain a value before the user can continue. My idea is to change the color of those cells that are empty - which works. But now I'm trying to figure out the best way to recheck the cells and reset the color to white, where I might need to do this several times, depending if the user actually entered data in all 8 cells. Right now I'm using 8 separate If statements to check the cells for values. Thanks Cindy -----Original Message----- Cindy, Try something like the following. Range("A1").Interior.ColorIndex = 6 'yellow -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cindy" wrote in message ... Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy . . |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set background color of a cell in VBA
-----Original Message----- Anyone know how to change the background color of a cell in Excel 2000 VBA code? Thank you Cindy . You need to use the Interior property of the Range object: Range("A1").Interior.Color = ColorValue ColorValue is a number specifying the color, or you can use the RGB function RGB(RedValue,GreenValue,BlueValue) where RedValue,GreenValue, and BlueValue are 0-255. For example, yellow is pure red and pure green mixed together or RGB(255,255,0). |
| 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 | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
| Color of Cell Background | Excel Programming | |||
Hybrid Mode
