Changing cell colors with a keyboard buttun

[Ram_6833]

Hi All.

Hope everyone is good.

I was wondering if anyone could help me about changing selected cells colour with a button from a keyboard (not a command button)

For example if I highlighted cells C1:C10 and want to change those cell colours to colour green is there a quicker way to do it "I.e assigning a specific button/key from the keyboard to turn those selected cells to green" rather than clicking onto fill colour and selecting the colour with a mouse?

Thanks in advance

[maniacb]

You can write a macro like

Please Login or Register  to view this content.

and assign a shortcut to it.(Go to View->Macros->Select Macro->Options)

[Ram_6833]

You can write a macro like

Please Login or Register  to view this content.

and assign a shortcut to it.(Go to View->Macros->Select Macro->Options)

That’s great many thanks

[maniacb]

If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.