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

[Timon]

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!

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

Yes, it will only run one rule but it looks as if you only need one to work.

What formulas did you use?

 

[Timon]

Re: Use Excel color scale to do gradient with more than 3 points (Solved)

Hi and welcome to the MrExcel Message Board.

Yes, it will only run one rule but it looks as if you only need one to work.

What formulas did you use?

Thank you very much for the follow up! I actually just solved this problem by using macros to do the gradient.

 

[RickXL]

Re: Use Excel color scale to do gradient with more than 3 points (Solved)

OK, thanks for letting me know.

Regards,