Formatting two colors in the same cell

  • Thread starter Thread starter Mamede
  • Start date Start date
M

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...
 
hi
you can have multiply colors for text(not formulas) but background is one
or none.

regards
FSt1
 
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
 
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.
 
Thanks... I "knew" I could do it!
Cheers, M

pdberger said:
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
Click to expand...
 
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!
 
Back
Top