Use Excel color scale to do gradient with more than 3 points

Closed
Dingman - Feb 11, 2016 at 09:27 PM
Hello,

I would like to use Excel color scale to do a conditional formatting on some cells.
If the cell value < 0 --> cell color is red
If 0<=cell value <1 -> cell color is a gradient chaging from red to yellow
If the cell value is 1 --> cell color is yellow
If 1< cell value is <=2 --> cell color is a gradient changing from yellow to green
If cell value =2 --> cell color is green
If 2<cell value <=3 --> cell color is a gradient changing from green to yellow
If cell color =3 --> cell color is yellow
If 3< cell value < 4 --> cell color is gradient changing from yellow to red
If cell value >=4 --> cell color is red

I tried using multiple rules in the color scale but it seems the cell only recognize 1 rule at a time. Can someone help me to create this? Thanks!

Related: