+ Reply to Thread
Results 1 to 4 of 4

Cell fill colors in Excel 2010

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    Connecticut
    MS-Off Ver
    2010
    Posts
    10

    Cell fill colors in Excel 2010

    At any given time, I utilize 2 - 3 different font fill colors. Is there a way to have at least 2 available fill colors available to me on the ribbon? If so, it would make things quicker if I didn't have to use the pull down menu each time I want to change the fill color.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Cell fill colors in Excel 2010

    I could not find a built-in way to make a specific fill color available on the ribbon. The way I would do this is to write two macros and put them in your PERSONAL.XLSB macros, then add buttons on the ribbon to call them. Here is an example that fills the selected range with red. (Your title and last sentence refer to "fill color" so I assume that's what you want. Your first sentence says "font fill colors" but font color and fill color are two different things.)

    First, hit ALT-F11 to open the VBA development window.
    At the left is an object navigator. You should see an object for PERSONAL.XLSB.
    Right-click on its name and select Insert, Module.
    Now you see a new line item, probably called, Module1, and the window to the right will be a code window for that new module.
    Paste this code into the code window:
    Please Login or Register  to view this content.
    Right-click anywhere on the ribbon. Select Customize the Ribbon.
    Above the list on the left is a dropdown. Select Macros.
    Look for the macro PERSONAL.XLSB!FillRed, and click it to highlight.
    On the list on the right, click on the + sign next to Home, then click on Font.
    Under the list, click on New Group. You can then click Rename to name the new group whatever you want. I called it "Fill Colors". This is the group name that will be shown on the ribbon.
    Single click on your new group, then click the Add button in between the two lists.
    On the list on the right, click on the name of the macro you just added. Click on Rename to rename it and select an icon for it. This is the name used to display it on the ribbon.
    Click OK.
    Now you have a new panel on the ribbon under the Home tab that has your new fill color button.
    Repeat the procedure to add other macros for other colors.

    If you want these buttons to be on the Quick Access Toolbar instead of or in addition to the ribbon, you can add the same macro by following a similar procedure, clicking on Customer Quick Access Toolbar instead of Customize the Ribbon, and follow the same steps.
    Last edited by 6StringJazzer; 01-31-2015 at 11:00 AM. Reason: corrections shown in blue
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-19-2014
    Location
    Connecticut
    MS-Off Ver
    2010
    Posts
    10

    Re: Cell fill colors in Excel 2010

    Thank you for your quick response. My apologies for "mis-speaking" and referencing font, it is the fill color I am interested in having more than 1 choice readily available at any given time. I started to follow your instructions, however alt & F11 doesn't do anything...any suggestions?

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Cell fill colors in Excel 2010

    Are you pressing them at the same time?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 16
    Last Post: 12-12-2014, 06:19 AM
  2. Gradient fill a point with 2 general colors (excel 2010)
    By spacely in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-16-2012, 05:05 PM
  3. cell fill colors in excel 2002 sp3
    By T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  4. cell fill colors in excel 2002 sp3
    By T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  5. Can't format font colors or cell fill-in colors
    By canoeron in forum Excel General
    Replies: 3
    Last Post: 08-22-2005, 07:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1