Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Fill a Cell with a color in VBA

  1. #1
    Join Date
    17th August 2006
    Posts
    20

    Fill a Cell with a color in VBA

    Hi fellows,

    I have a question, can I fill a cell with a color in VBA? If is that possible, how can I do it?

    Kind Rewards.


    Pedro

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Fill a Cell with a color in VBA

    VB:
    Sheet2.Range("A1:D2").Interior.ColorIndex = 5 
    
    
    Easiest way to get your needed ColorIndex is to simply Record a macro using the needed color.

  3. #3
    Join Date
    17th August 2006
    Posts
    20

    Re: Fill a Cell with a color in VBA

    Thank you Dave. You're Kind and nice
    huges

    Pedro

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 5
    Last Post: March 14th, 2008, 23:22
  2. Fill Cell Color When Certain Criteria Met
    By playdoepete in forum EXCEL HELP
    Replies: 2
    Last Post: March 7th, 2008, 01:47
  3. Fill a cell with a color with IF function
    By beboppin in forum EXCEL HELP
    Replies: 1
    Last Post: August 23rd, 2005, 14:19
  4. Fill or color a cell without printing that fill....
    By ITSCdanimal in forum EXCEL HELP
    Replies: 1
    Last Post: April 22nd, 2005, 15:57
  5. if statement to fill color in a cell
    By lovethewestlady in forum EXCEL HELP
    Replies: 2
    Last Post: July 27th, 2004, 10:13

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno