![]() |
#2
|
||||
|
||||
![]()
If you want to do it manually, I suppose the easiest way is the following key sequence:
<Shift-Space> (which selects the entire row for the current cell. If the current selection takes in cells on more than one row, the selection is extended to all those rows.) <Alt-H> (which selects the Home tab on the ribbon, if you're using Excel 2010. If you're using an earlier version, this sequence will have to change.) <H> (to open the highlighting window) Then click on the desired color. There may be a keystroke that will let you select the color, but I'm not aware of it. And there might even be a way to create a keystroke that will do all of the above, without writing something in VBA. But I tend to use VBA a lot, so if there's another way I'm not sure what it might be. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
Is there a way to automatically highlight the column and the row that of the current | Jamal NUMAN | Excel | 8 | 02-14-2012 02:58 PM |
![]() |
Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
![]() |
Johnny thunder | Word VBA | 3 | 04-07-2011 04:44 PM |
highlight cell after checkbox | flatk | Word | 0 | 01-25-2007 12:32 PM |