Excel Formatting - is two gradient fills in one cell possible?

[mhasham]

Hello Folks,

I am wondering if it is possible to run multiple conditional formatting gradient fills in one cell.

EXAMPLE.
- I have a cell that has a maximum of 80 set as the limit and if fills the cell with a gradient colour half way if the number in the cell is a 40

Is is possible to colour the remainding portion of this cell with another color?


Thanks.

 

[BiocideJ]

Not for half of the cell, but you COULD have a lighter color for 40 and a darker shade for 80.

Any other possibility would have to be an outside-of-the-box idea.