Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools

img

Set cell background color programmatically

/
/
/
265 Views

The line you should use when you need to set a new background color to a cell is:

Sheets(“Sheet1”).Range(“C3”).Interior.Color = RGB(255, 255, 0)

The color will be yellow. For other colors please see the color map article.

  • Facebook
  • Twitter
  • Google+
  • Linkedin
  • Pinterest

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

This div height required for enabling the sticky sidebar