Keyboard Shorts for Common Operations

[Sam Benson]

I spend a lot of time needing to highlight certain cells. Is there anyway I
can assign a keyboard shortcut to the 'fill color' tool and 'font colour'
tool so I don't have to take my hands off the keyboard (using a mouse slow
me down)

They are not predefined Excel keyboards shortcuts (using Excel 2000) and I
can't see how to define them


Regards

Sam

 

[Frank Kabel]

Hi
try recording a macro while doing this manually and assign this macro
to a shortcut

 

[David McRitchie]

Hi Paul,
Recording a macro would tell you what commands
you might want to use,

Sub ReColorize()
selection.interior.colorindex = 35 'Light Green
selection.font.colorindex = 55 'Indigo
end sub

To install / use a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
includes setting up the keyboard shortcut

To see colorindex colors you can refer to
http://www.mvps.org/dmcritchie/excel/colors.htm#colorindex

For myself, I would use the mouse, select all the cells to be
changed and then invoke the macro.

If all of the cells that you want to color are because of something
that you can make up a formula resulting in False (value 0) or
True (anything else) then you can have this done automatically
with a Conditional Formula
http://www.mvps.org/dmcritchie/excel/condfmt.htm
for example all the cell in Column C is less than the value of the
cell in Column B.
Select all cells (ctrl+A) or column C depending on what is to be colored
Any cell on row 1 can be the active cell (usually has to be a specific cell)
Format, Conditional Formula, (enter formula), (enter formatting options)
Formula 1 is: =$C1<$B1
or perhaps: =IF(AND(NOT(ISEMPTY($A1),$C1<$B1), True, False)