+ Reply to Thread
Results 1 to 3 of 3

2 colour background in cells. V16 for MacBook Pro

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    Gosport, Hants
    MS-Off Ver
    V16 Excel
    Posts
    3

    2 colour background in cells. V16 for MacBook Pro

    Hi.

    Iím trying to add 2 colour shading to cells g3 to s13.
    Selecting Format >Cells > Fill does not come up with the colour chart or options to select Two colours like in older versions. I am using v16.2 on a MacBook Pro.

    Thanks in anticipation.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,544

    Re: 2 colour background in cells. V16 for MacBook Pro

    Try clicking on "Fill Affects"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-08-2019
    Location
    Gosport, Hants
    MS-Off Ver
    V16 Excel
    Posts
    3

    Re: 2 colour background in cells. V16 for MacBook Pro

    Quote Originally Posted by FDibbins View Post
    Try clicking on "Fill Affects"
    Thanks.

    I have tried all sorts to get it to work. Clicked on FORMAT > CELLS > FILL. TH
    His gives you Background Color Pattern Color
    No Color. Automatic

    Clicking on either of these gives you the colour palette but no choice of two Colors in the same cell, which is what I’m after.

    Thanks

+ 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. [SOLVED] format a cell background colour based on a manual background colour of an adjacent cell
    By Nampara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2018, 04:03 PM
  2. [SOLVED] Search cells based on student name, cell background colour and return a tally for colour
    By drof_06 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-26-2016, 04:31 AM
  3. Select cells by Background colour
    By WCE_123 in forum Excel General
    Replies: 2
    Last Post: 07-28-2015, 09:14 AM
  4. Auto copy cells including a cells Coloured background (colour fill)
    By rick.parry in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2013, 04:51 AM
  5. [SOLVED] sum up cells by background colour
    By Mengo85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 01:27 PM
  6. Counting cells containing a certain background Colour
    By paulizaz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2008, 08:26 AM

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