fill color & font color

[sandeephg]

I have large data where I have to fill color in cell frequently. Please some one can tell me what is the shortcut for fill color & font color……

[VBA Noob]

Just turn on the VBA recorder select a cell and format the font and cell colour

http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

Then assign a shortcut key.

http://office.microsoft.com/en-us/ex...893721033.aspx

example of code

Please Login or Register  to view this content.

VBA Noob