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

[zotah]

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

 

[Michael M]

Can't be done with a formula.
You may be able to Conditional Fomat the cells, but I doubt it.
It sounds like a very strange way to format cells though !!!
Here's 2 codes, 1 for yellow 1 for green
and look here for instructions on how to attach it to your toolbar in excel 2007 or higher !

How to Add an Excel 2010 Macro to the Quick Access Toolbar - For Dummies

Sub MM1()
    With Selection.Interior
        .Color = vbYellow
    End With
End Sub
Sub MM2()
    With Selection.Interior
        .Color = vbGreen
    End With
End Sub

 

[zotah]

Can't be done with a formula.
You may be able to Conditional Fomat the cells, but I doubt it.
It sounds like a very strange way to format cells though !!!
Here's 2 codes, 1 for yellow 1 for green
and look here for instructions on how to attach it to your toolbar in excel 2007 or higher !

How to Add an Excel 2010 Macro to the Quick Access Toolbar - For Dummies

Sub MM1()
    With Selection.Interior
        .Color = vbYellow
    End With
End Sub
Sub MM2()
    With Selection.Interior
        .Color = vbGreen
    End With
End Sub

Thanks,

Maybe Excel will upgrade this feature on the next Excel Version.
This sounds like it would be easy for excel to fix this problem easily anyway.

Thanks Zotah