Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multicolor Cell Formatting (2000)

    is it possbile to make a cell have 2 color ie top half green bottom red?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Multicolor Cell Formatting (2000)

    Not that I am aware of, but you could colour 2 cells and make sure that they don't have borders, so that the cells would look like they are one cell divided in two.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Lounger
    Join Date
    Oct 2003
    Location
    Birmingham, England
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multicolor Cell Formatting (2000)

    see attached.

    As you'll have figured, it's all done with smoke and mirrors, or at least autoshapes and a text box.

  4. #4
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multicolor Cell Formatting (2000)

    John

    Exactly how did you do that ?

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multicolor Cell Formatting (2000)

    He added 2 rectangles that are each half the size as the cells. The properties have them move/size with the cell. The cell "contents" are in a text box over the rectangles.

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Multicolor Cell Formatting (2000)

    Another way to do this, if you want the cell to have "calculated" contents.
    <UL><LI>Put the data you want in a cell (e.g. D1 in this example)
    <LI>Edit copy
    <LI>Move to the cell where you want the coloured version (Cell B1 in this example)
    <LI>press shift before clicking the edit menu again and choose "Paste Picture Link"
    <LI>Use the standard fill colour to create a graduated fill[/list]StuartR

Posting Permissions

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