Set background color of a cell in VBA

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Anyone know how to change the background color of a cell
in Excel 2000 VBA code? Thank you

Cindy
 
I suggest the best method would be to record a macro of the chang
required
 
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
 
-----Original Message-----
Anyone know how to change the background color of a cell
in Excel 2000 VBA code? Thank you

Cindy
.
Click to expand...
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).
 
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
 
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
 
That was one of my first thoughts but there is no criteria
for a "null" cell.
 
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
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
GridLines Inadvertantly Goes Away with Macro 3
conditional format - table - cell empty return default color 1
count cells with diagonal borders 3
Remove Hyperlinks Without Changing background shading 14
Excel VBA 1
Count cells with content in different color background 2
Application-defined or Object-defined-error when changing color in 1

Back
Top