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

mhasham

Board Regular
Joined
Feb 28, 2013
Messages
63
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.
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

BiocideJ

Well-known Member
Joined
Jan 23, 2012
Messages
1,733
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,373
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top