[real-eyes] Re: Inputting multiple colors in excel spreadsheets
- From: "William Stephan" <wstephan@xxxxxxxxxxxxx>
- To: <real-eyes@xxxxxxxxxxxxx>
- Date: Fri, 13 Oct 2006 17:01:07 -0500
Thanks Denny, this is exactly what I need.
Bill Stephan
Kansas City, MO
(816)803-2469
William Stephan
-----Original Message-----
From: "Denny Huff"<lists@xxxxxxxx>
Sent: 10/13/06 4:24:23 PM
To: "real-eyes@xxxxxxxxxxxxx"<real-eyes@xxxxxxxxxxxxx>
Subject: [real-eyes] Re: Inputting multiple colors in excel spreadsheets
Bill,
If you want to record a makro to do this for you, it can be done
rather easily.
Do an alt t for the tools menu, type an m for makro, arrow down to record
makro and press enter.
It will ask you for a makro name, so I would name it one of the colors you
are wanting to make the font. Tab to OK and press enter.
Now go through the procedure of selecting that color.
After you have selected that color, do another alt t, type the letter m for
makro and arrow down to stop recording and press enter.
To test your makro, go to another cell you want that color, do an alt f8 and
press enter on the name of the makro you want, in this case, the color you
named the makro.
Repeat this procedure for each color you will be using.
Then when you do the alt f8, you will have a list box of makro names for
each color you have recorded a makro for.
HTH
-----Original Message-----
From: real-eyes-bounce@xxxxxxxxxxxxx [mailto:real-eyes-bounce@xxxxxxxxxxxxx]
On Behalf Of William Stephan
Sent: Friday, October 13, 2006 12:05 PM
To: real-eyes@xxxxxxxxxxxxx
Subject: [real-eyes] Inputting multiple colors in excel spreadsheets
All:
I'm developing a spreadsheet in which there are status columns. The column
contains dates, and the colors black, green and red are used to indicate:
completed, projected, and failed respectively.
To input this data park my cursor on the appropriate cell, do a control+1
which brings me to the fonts tab within formatting. Then, I tab to "color"
and arrow down to whichever color I want and hit enter. Then, I tab to OK,
and the color for the selected cell is changed accordingly.
This works, but it's a little more time-consuming than I'd like. Is there a
relatively easy way to "automate" this? I know there are macros available,
but I've never used them.
Thanks for any suggestions.
Bill Stephan
Kansas City, MO
(816)803-2469
William Stephan
To subscribe or to leave the list, or to set other subscription options, go
to www.freelists.org/list/real-eyes
To subscribe or to leave the list, or to set other subscription options, go to
www.freelists.org/list/real-eyes
To subscribe or to leave the list, or to set other subscription options, go to
www.freelists.org/list/real-eyes
Other related posts:
