<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

Q1(a) Make a shortcut Ctrl + r which should automatically make cell blue


-a-

-ea-
Q1(b) Assign button for previous shortcut like

 

Creating a simple shortcut and button - Macros

If we click this button,cell should automatically become blue

-a-

-ea-

 

Q1(c) Save this file containing  macro and Name it MACRO Q1

-a-

-ea-

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Jail