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
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