Hotkeys for text & background coloring

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
> >
> >
>
>