Try this bit of code, it uses the selected cells:

Sub MakeCellGreenAndBold()
' uses the selected cell
With Selection
With .Interior
.ColorIndex = 35 ' or try 4 or 50
.Pattern = xlSolid
End With
.Font.Bold = True
End With
End Sub

--

change
.ColorIndex = 35 ' or try 4 or 50
to be 4 or 50 for a different color.

You then have to insert a button and assign the macro.

Note if you want a specific cell change

With Selection
to
With ActiveSheet.Range("A1")

HTHs Martin


"nshanmugaraj" wrote:


hi,
I am new to Excel programming...
can any one say how to write a macro to make a cell color = "green" and
the font = "bold" ... when cliking a button

i will be happy if you send me the coding since i am new to excel
programming


Thanks
N.ShRaj


--
nshanmugaraj
------------------------------------------------------------------------
nshanmugaraj's Profile: http://www.excelforum.com/member.php...o&userid=31570
View this thread: http://www.excelforum.com/showthread...hreadid=512644