Hotkeys for text & background coloring

0

0-0 Wai Wai ^-^

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

OZDOC1050

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
 
0

0-0 Wai Wai ^-^

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 ^-^ said:
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.
Click to expand...
Click to expand...
 
Top