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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

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,112,816
Messages
5,542,660
Members
410,567
Latest member
SCraig123
Top