keyboard short cut for highlighting a field

C

Cindy

is there a keyboard short cut or a way to create a shortcut to hightlight a
cell easily with a default or specific color.
 
G

Gord Dibben

As Dave Peterson points out in another message, this could be changed to do all
cells at once without the loop.

Sub color_it()
Selection.Interior.ColorIndex = 3 'red
End Sub


Gord
 
G

Gord Dibben

Geez

Now I'm chasing around to all my latest posts and advising OP's of your advice.

Again.......thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell protection short cut button 1
Short-cut is dead 2
Keyboard shortcut for Paste Special-Values 4
short cut keys for navigation 1
Is there a one button shortcut for "copy cell above & paste here" 4
short cut key 2
input time by keybrd in locked worksheet 2
Is there an easy keyboard shortcut to scroll between worksheets? 1

Top