Hotkeys for text & background coloring

Hi.
Does anyone know the hotkeys for text coloring (font color) & background
coloring (fill color)?

Eg:
First you need to select the font color & fill color in the related toolbar
incons.
- When I highlight "I am great", then press "Ctrl+O" for example, the text will
be colored as what it's displayed in the "font color" toolbr icon.
- The simliar way applies to background coloring

If the above is not available, any workaround is still apreciated.

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

You could use a small macro to use as a wokaround and have as many
combinations as you want, im running some stuff at the moment so cant bring
up a sample for you but from the top of my head something like

you would need to put range here ( for each cell ) or a loop similar to

sub colourme()
range b1.select
do until activecell.value = ""


if activecell.value = range a1.value then cell colour / cell font =
else
if activecell.value = range a2.value then cell colour / cell font =
and so on
end if

activecell.offset(1,0).select
loop
end sub

in range a1 = " i am great"
in cell a2 = " try this"

down as far as you want to go

just one way hope it helps
Pete

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:%237bhfbgqFHA.4044@TK2MSFTNGP09.phx.gbl...
>
> Hi.
> Does anyone know the hotkeys for text coloring (font color) & background
> coloring (fill color)?
>
> Eg:
> First you need to select the font color & fill color in the related
> toolbar
> incons.
> - When I highlight "I am great", then press "Ctrl+O" for example, the text
> will
> be colored as what it's displayed in the "font color" toolbr icon.
> - The simliar way applies to background coloring
>
> If the above is not available, any workaround is still apreciated.
>
> --
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>

Your idea sounds good.
Unfortunately I don't know muhc about macros.

Would you mind providing the whole scripts for these macros?
PS: If the request is indeed demanding or the work of providng the whole script
is tedious, forget my request.


> You could use a small macro to use as a wokaround and have as many
> combinations as you want, im running some stuff at the moment so cant bring
> up a sample for you but from the top of my head something like
>
> you would need to put range here ( for each cell ) or a loop similar to
>
> sub colourme()
> range b1.select
> do until activecell.value = ""
>
>
> if activecell.value = range a1.value then cell colour / cell font =
> else
> if activecell.value = range a2.value then cell colour / cell font =
> and so on
> end if
>
> activecell.offset(1,0).select
> loop
> end sub
>
> in range a1 = " i am great"
> in cell a2 = " try this"
>
> down as far as you want to go
>
> just one way hope it helps
> Pete
>
> --
> (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
> "0-0 Wai Wai ^-^" <x@x.com> wrote in message
> news:%237bhfbgqFHA.4044@TK2MSFTNGP09.phx.gbl...
> >
> > Hi.
> > Does anyone know the hotkeys for text coloring (font color) & background
> > coloring (fill color)?
> >
> > Eg:
> > First you need to select the font color & fill color in the related
> > toolbar
> > incons.
> > - When I highlight "I am great", then press "Ctrl+O" for example, the text
> > will
> > be colored as what it's displayed in the "font color" toolbr icon.
> > - The simliar way applies to background coloring
> >
> > If the above is not available, any workaround is still apreciated.
> >
> > --
> > Additional information:
> > - I'm using Office XP
> > - I'm using Windows XP
> >
> >
>
>

You could make up your own macro to work like the Format Painter
http://www.mvps.org/dmcritchie/excel/paste.htm#formats
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"0-0 Wai Wai ^-^" <x@x.com> wrote in message news:%237bhfbgqFHA.4044@TK2MSFTNGP09.phx.gbl...
>
> Hi.
> Does anyone know the hotkeys for text coloring (font color) & background
> coloring (fill color)?
>
> Eg:
> First you need to select the font color & fill color in the related toolbar
> incons.
> - When I highlight "I am great", then press "Ctrl+O" for example, the text will
> be colored as what it's displayed in the "font color" toolbr icon.
> - The simliar way applies to background coloring
>
> If the above is not available, any workaround is still apreciated.
>
> --
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>

On the page I referenced
http://www.mvps.org.com/excel/paste.htm
are references to getstarted.htm like in the following:

Getting Started with Macros how to install and use a macro. General purpose macros like the ones described on the page (paste.htm)
should be installed in your personal.xls workbook and your personal.xls workbook should be hidden (Window, hide) so they are
available to any open workbook.
http://www.mvps.org.com/excel/getstarted.htm