Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: How Do I create 2 separate independent (Fill Color) buttons?

  1. #1
    Board Regular
    Join Date
    Feb 2014
    Location
    California
    Posts
    89
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How Do I create 2 separate independent (Fill Color) buttons?

    How Do I create 2 separate independent (Fill Color) buttons?

    I need to highlight hundreds of indepentant excel cells and conditional formating isn't what I need to make this work. I just use the (Fill Color) button and it works great. However it slows me down having to switch different colors every time I use the (Fill Color) button over and over again. I use primarily 2 colors all the time.

    When I duplicate the (Fill Color) button so I have 2 (Fill Color) buttons on my access toolbar it duplicates the same color that I have on the first (Fill Color) button.

    How do I set it up so I can have 2 (Fill Color) buttons that are indepentent of each other so I don't have to switch colors back and forth over and over again?

    Thanks for any advice on this hugh problem,

    Zotah

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    Why not simply hold down the CTRL key whil clicking on each cell, then select the colour you want.
    It will then colour ALL selected cells
    The do the other cells the same way
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Jan 2014
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?


  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    You still haver to select the cells........why use an Addin or macro that replicates a native Excel function...
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  5. #5
    Board Regular
    Join Date
    Jan 2014
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    I assume he is selecting many non continuous cells. Using ctrl you have to start over if you select a wrong cell. Using this add-in you can quickly change the colors of cells a few at a time quickly. It would most likely be best to have excel auto color the cells, but zotah has not asked for help with that.

  6. #6
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    I'm afraid we'll have to agree to disagree on this one...
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  7. #7
    Board Regular
    Join Date
    Feb 2014
    Location
    California
    Posts
    89
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    Quote Originally Posted by Michael M View Post
    Why not simply hold down the CTRL key whil clicking on each cell, then select the colour you want.
    It will then colour ALL selected cells
    The do the other cells the same way
    The cells I determine the color for are related to the first colors I highlighted. So for example if I color 3 cells with yellow. The 3 yellow cells are what tell me that the 4th cell needs to be green. If I do let's say 500 cells yellow on different cells and then go back and do the rest green if will take me twice as long to find out which one's I need to figure out that are supposed to be green. In this way it's so much easier to just click them yellow and then click on another (Color Fill) to green.

    What I'm trying to figure out is if there is away to have 2 Color fill buttons indepentant of each other so I don't have to take the time each color to switch the colors back and forth and back and forth over and over again. It drives me crazy.

    Zotah

  8. #8
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    Why don't you determine what cells need to coloured yellow by criteria, and we could than possibly automate it for you !!!
    In other words, why do you make that cell yellow ?.....
    Is it below a certain number ?
    Does it have a certain text ?
    Is it Bold or underlined?

    Any of these could trigger the cell to turn yellow

    BTW
    You do know you can drag the colour pallete onto the worksheet, so you don't have to keep selecting it, don't you ???
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  9. #9
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    You do know you can drag the colour pallete onto the worksheet, so you don't have to keep selecting it, don't you ???
    Should have advised that this only works for 2003 or earlier....thanks to Microsoft enhancing our experience !!!
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  10. #10
    Board Regular
    Join Date
    Feb 2014
    Location
    California
    Posts
    89
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How Do I create 2 separate independent (Fill Color) buttons?

    Quote Originally Posted by Michael M View Post
    Why don't you determine what cells need to coloured yellow by criteria, and we could than possibly automate it for you !!!
    In other words, why do you make that cell yellow ?.....
    Is it below a certain number ?
    Does it have a certain text ?
    Is it Bold or underlined?

    Any of these could trigger the cell to turn yellow

    BTW
    You do know you can drag the colour pallete onto the worksheet, so you don't have to keep selecting it, don't you ???
    Ok so let me think about that. First question I have for you is, Does excel not have a way to have 2 independent (Color Fills) I was hoping this was an easy fix. If not then let's see if we can go with your idea.

    I have a list of 9000 numbers all going down multiple columns.

    As I look down on column if I see the number go below -30 I need to high light that one number only to yellow. If I see the number continue down below -50 I need to high light that one number with green. The number will not always be -50 it might be -53 or -63 depending or not weather that's the closes number to -50. then as I'm looking down the same column of numbers I have a number plus 25 then I look to see if the numbers below ever reach a plus 15 or less. If they do I need to highlight the plus 25 or plus 26 etc to a yellow color and if the number goes below a plus 15 I need to color this number green. But this could also be a plus 14 or a plus 13 if a plus 15 is not there.
    If the number is 25 or 26 etc and the number goes up to a plus 50 I need to color this number a yellow or a green depending on weather the number goes up to a plus 75 or not. If the number does not go up to a plus 75 then I would color the plus 50 with a green color. If the number does in fact go up to plus 75 then I would color the plus 50 with a yellow color and color the 75 with a green color. If however there is a plus 100 somewhere down the list then the plus 75 would be a yellow color and the 100 or 101 or 102 or 103 etc. whatever comes first would be a green color and the 75 would be yellow. So as I said it depends on the future number ahead will determine weather or not that particular cell is going to be green or yellow.

    After knowing all this do you have some type of formula that can figure all this out. I was hoping it wasn't going to be this big of a problem.

    I guess the main question I have first is (Can Excel 2010) give us 2 independant (Color Fills) So all I have to do is click on each color fill independantly On color fill being one independent color and the other color fill button being another independant color. This would double my speed of not having to switch the colors back and forth thousands of times.

    thanks for any advice you can give me on this problem

    Zotah
    Last edited by zotah; Mar 5th, 2014 at 08:29 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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