keyboard short cut for highlighting a field
 

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

keyboard short cut for highlighting a field
 

None that I have ever heard of.

A macro with a shortcut key could do the trick

Sub color_it()
For Each cell In Selection
cell.Interior.ColorIndex = 3 'red
Next
End Sub

Assign a shortcut key combo.


Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 15:42:00 -0800, Cindy
wrote:

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

keyboard short cut for highlighting a field
 

Or do it all in one line:

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

<vbg

Gord Dibben wrote:

None that I have ever heard of.

A macro with a shortcut key could do the trick

Sub color_it()
For Each cell In Selection
cell.Interior.ColorIndex = 3 'red
Next
End Sub

Assign a shortcut key combo.

Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 15:42:00 -0800, Cindy
wrote:

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

--

Dave Peterson

keyboard short cut for highlighting a field
 

If I have lots of cells to color, i color the first one and then
select the others and press Alt + Enter, which repeats the last
command, in that case coloring.

Maybe that helps you

Carlo

On Jan 18, 9:05*am, Gord Dibben <gorddibbATshawDOTca wrote:
None that I have ever heard of.

A macro with a shortcut key could do the trick

Sub color_it()
For Each cell In Selection
* * *cell.Interior.ColorIndex = 3 * 'red
Next
End Sub

Assign a shortcut key combo.

Gord Dibben *MS Excel MVP

On Thu, 17 Jan 2008 15:42:00 -0800, Cindy
wrote:



is there a keyboard short cut or a way to create a shortcut to hightlight a
cell easily with a default or specific color.- Hide quoted text -

- Show quoted text -

keyboard short cut for highlighting a field
 

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

On Thu, 17 Jan 2008 16:05:06 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

None that I have ever heard of.

A macro with a shortcut key could do the trick

Sub color_it()
For Each cell In Selection
cell.Interior.ColorIndex = 3 'red
Next
End Sub

Assign a shortcut key combo.


Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 15:42:00 -0800, Cindy
wrote:

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

keyboard short cut for highlighting a field
 

Geez

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

Again.......thanks

On Thu, 17 Jan 2008 18:21:36 -0600, Dave Peterson
wrote:

Or do it all in one line:

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

<vbg

Gord Dibben wrote:

None that I have ever heard of.

A macro with a shortcut key could do the trick

Sub color_it()
For Each cell In Selection
cell.Interior.ColorIndex = 3 'red
Next
End Sub

Assign a shortcut key combo.

Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 15:42:00 -0800, Cindy
wrote:

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