Another tip.

Turn on the macro recorder in tools=Macro=Record a New Macro

then select the cell and change the color manually.

then turn off the macro recorder and look at the recorded code.

--
Regards,
Tom Ogilvy


"owl527" wrote in
message ...

Hi,
how do I set the color of a sell using VB? please let me know. Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=488595