Formatting two colors in the same cell

[Mamede]

Does anyone know how to format 2 colors in the same cell? Does Excell 2007
have this feature (I didn't find in 2003)? Note, it is not conditional
formatting, but stripes. And it is not pattern either! I want "large" stripes
or just two band color, with continued text crossing both colors...

 

[Jim Thomlinson]

A cell can only have 1 fill colour that I know of...

 

[FSt1]

hi
you can have multiply colors for text(not formulas) but background is one
or none.

regards
FSt1

 

[pdberger]

Mamede --

If you navigate to formatting the cells (easiest way -- select and
right-click on the cells, >Format Cells, >Fill), you can select a pattern
style. You only select one color, which will replace the white in a
black-and-white pattern, but it's better than nothing.

The only way I know of to select two different colors is to navigate to the
same place and select Fill Effects, and you can have a two-color fade from
one to the other.

HTH

 

[ShaneDevenshire]

Don't give up, you can do this in 2007!

Select the cell(s) and right click and choose Format Cells, then choose
Fill, Fill Effects. Pick a Color 1 and a Color 2, try the Vertical style and
see if you like that. This is actually a gradient fill but it does produce
two colors for the fill, and a mix as they merge.

 

[Mamede]

Thanks Shane, I will upgrade to 2007!
Best,
Mamede

 

[Mamede]

Thanks... I "knew" I could do it!
Cheers, M

Mamede --

If you navigate to formatting the cells (easiest way -- select and
right-click on the cells, >Format Cells, >Fill), you can select a pattern
style. You only select one color, which will replace the white in a
black-and-white pattern, but it's better than nothing.

The only way I know of to select two different colors is to navigate to the
same place and select Fill Effects, and you can have a two-color fade from
one to the other.

HTH

 

[Mamede]

I found another question on the board which is a solution to my question as
well.
We may use 2 columns (or 2 cells if you prefer) and center the text across
selection. Clean and easy!