Shortcut Key for Text Changing Color in MS- Excel

H

Hema

Please let me know how go assing the shortcut key for Fill Color and Font
Color in MS-Excel. Is MS-Excel having the feature of shortcut key for
formatting option.
Pls send ur reply to me on my e-mail id :- [email protected]
 
R

Ron de Bruin

Hi Hema

Not build-in

Bold and Italic is possible but no colors
You can make your own macro if you want
Record a macro in your personal workbook

Selection.Interior.ColorIndex = 35
 
H

Hema

Thanks for givien the ans of my question. I am sucessfully able to work/find
the macro for fill color, but I am anable to make a macro for Font Color(Text
Changing Color) in MS-Excel. Please porvided me the coding for making the
macro for Font color.

Please reply to me on my email id: [email protected].
 
Top