ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Colors (https://www.excelbanter.com/excel-discussion-misc-queries/61594-cell-colors.html)

David Zoretic

Cell Colors
 
Is there any way I can have three seperate colors in a single cell, either
horizontal or vertical?

JE McGimpsey

Cell Colors
 
No, but you could place three separately colored transparent shapes on
top of the cell.

In article ,
"David Zoretic" <David wrote:

Is there any way I can have three seperate colors in a single cell, either
horizontal or vertical?


Dave Peterson

Cell Colors
 
Maybe you could put rectangles (from the drawing toolbar) over the cell and
color them???

David Zoretic wrote:

Is there any way I can have three seperate colors in a single cell, either
horizontal or vertical?


--

Dave Peterson

exceluserforeman

Cell Colors
 
Alternatively,
Make three skinny columns, one for each color.



"David Zoretic" wrote:

Is there any way I can have three seperate colors in a single cell, either
horizontal or vertical?


ScottO

Cell Colors
 
Another work-around ...
It's a bit fiddly, but you can put 3 text boxes over the cell, and
then fill them with different colours.
If you want to see cell values, then you need to increase the
Transparency %.
HTH
Rgds,
ScottO

"exceluserforeman" wrote
in message ...
| Alternatively,
| Make three skinny columns, one for each color.
|
|
|
| "David Zoretic" wrote:
|
| Is there any way I can have three seperate colors in a single
cell, either
| horizontal or vertical?




All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com