I think that when you multiple copies of Excel's default fill color button on your toolbar, their colors are linked and can't be separated. What you could is put some macro buttons on your toolbar and assign macros that change cells' colors to them.
Sub FillColorRed()
Selection.Interior.ColorIndex = 3
End Sub
Sub FillColorBlue()
Selection.Interior.ColorIndex = 5
End Sub
Sub FillColorYellow()
Selection.Interior.ColorIndex = 6
End Sub
These three macros change a the selected cell's color to red, blue, and yellow respectively. The downside is that the colors that the buttons are linked to are fixed, so if you wanted one of the buttons to change the color to green rather than red, you'd have to change the code.
-Ben
GLITZ, are you aware that the fill toolbar's
dropdown palette can be "torn off" and then
allowed to float above the worksheet? This
effectively gives you 40 fill colors at your
finger tips!
This is kinda what i was looking for.........let me explore the idea of the macro's. Thanks
Yea, I know about the pull down. I've made a worksheet for an excel rookie, and I want to make it as easy as possible......