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 the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

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,113,907
Messages
5,544,984
Members
410,647
Latest member
LegenDSlayeR
Top