how do i create a button within a spreadsheet

[Guest]

I want to create some buttons within the spreadsheet so that i can select a
cell then hit the button and highlight the selected cell a certian color

 

[Paul B]

Brian, there is one on the formatting tool bar already, looks like a paint
can, fill color, will that work? If not you could use a macro something like
this and assign it to a button, view, toolbars, forms, click on the button
then click on your sheet, assign the macro to it
Sub Color_Yellow()
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003