Can you shade one cell 2 different colors?
I am establishing a payroll calendar where, 3-months out of the year, a
single day represents 2 different tasks. Each task is color shaded. Can you split a cell diagonally to shade 1/2 one color and the other 1/2 another color? I know I can do the cell in one shade and the number in a font color but it does not stand out like a diagonally shaded area would stand out. I want it noticed by those who will claim, "But, I didn't see that." Thanks for your help. |
Can you shade one cell 2 different colors?
A single cell cannot have two different backgrounds.
Maybe use drawing toolbar to add a couple of opaque objects? But that's a lot of fiddling. Excel has many cells...........why use one cell for two tasks? Gord Dibben MS Excel MVP On Tue, 2 Jun 2009 15:42:01 -0700, Rusty at kcmo <Rusty at wrote: I am establishing a payroll calendar where, 3-months out of the year, a single day represents 2 different tasks. Each task is color shaded. Can you split a cell diagonally to shade 1/2 one color and the other 1/2 another color? I know I can do the cell in one shade and the number in a font color but it does not stand out like a diagonally shaded area would stand out. I want it noticed by those who will claim, "But, I didn't see that." Thanks for your help. |
All times are GMT +1. The time now is 01:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com