Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Feb 2003
    Location
    Florida, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Two-color Cell Background Cell (Excel 2000)

    Somewhere on the Web or in some Excel book I saw once that there was a way to apply 2 colors to a cell background. Now that I need it for a presentation, I can't locate where I found it so I don't know how to do it. Anyone have any idea how or where this information might be located?
    Steve

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    I don't think you can actually apply different colors to a single cell, but it might be possible to make it look like you can. See this VBA Thread which has a workaround or two.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    Andrew - Picked up this link and explored. Where Oh Where did the camera tool come from.
    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    Tools > Customize > Commands > Tools > Camera

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    Hi Steve,
    Excel provides a means of setting two colours for cells, via Format|Cells|Patterns.

    If you use Format|Cells|Patterns, you'll see a palette of colours that you can choose from. Use this to set one of the colours. Next, click on the down tab next to the 'Pattern' pick box. This opens up a variety of patterns and another a palette of colours that you can choose from. Select your alternate colour, then re-open the pick box and choose whichever pattern gives the kind of effect you're looking for (eg vertical stripes). Unfortunately there aren't many patterns to choose from and you can't customise them.

    Another way of achieving the appearance of having more than one colour is to actually use multiple columns/rows and to place whatever is meant to be in the foreground into a transparent text box hovering over these. If the data to be displayed are variable, you can even attach a formula to the text box via the formula bar, and the results will show in the text box.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #6
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    Leif
    I feel so embarrased <img src=/S/blush.gif border=0 alt=blush width=15 height=15> at asking such a simple question. So easy and I now have a camera on my toolbar.
    Many thanks

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    Hey - don't feel embarrased!
    I had never heard of the camera either until I came upon it by accident in a post here!

    (It makes you realise - well, me anyway - how many other unknowns are buried there.)

  8. #8
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    Macropod wrote:
    If the data to be displayed are variable, you can even attach a formula to the text box via the formula bar, and the results will show in the text box.

    How, please? See mind-bending example, attached!

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two-color Cell Background Cell (Excel 2000)

    The formula can only be a direct reference to a single cell, in your case =E1 (you can hide column E if you like). The formula should be entered in the formula bar, not in the text box itself. See attached workbook.

Posting Permissions

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