macro to change font color of a cell

[James C]

I want 3 macros called R, and G, and B.

I select a cell, then I hit R and the font color goes to RED. Done
G goes to green.
and B goes to blue.

any help???

thanks very much

[Special-K]

Say you wanted to type the word READING into a cell after selecting it. How would Excel know that you were actually typing the letter R and didnt want to change the font colour?
Same question for G and B.

[john55]

try to record a macro, name it ctrl+r (for red) and you find yourself a solution. you'll feel better!

[James C]

hotkey to run the macro, e.g,
CTRL-SHIFT-R
CTRL-SHIFT-G
CTRL-SHIFT-B

[john55]

this can be a start

Please Login or Register  to view this content.