Conditional formatting with 3 colours depending on numbers.

[johannordgren]

Hello there.

I want to sort a coulumn of numbers in 3 colours, so I was trying to use conditional formatting, but I can't seem to get it right.
I managed my own rule with a "3 colour scale" but as I apply it to selected coulumn, nothing happens.
Do I maybe type the rule numbers wrong?

This is how I wrote it out. Please correct me.
[TABLE="width: 500"]
<tbody>[TR]
[TD]<50[/TD]
[TD]>=50<150[/TD]
[TD]>=150[/TD]
[/TR]
</tbody>[/TABLE]

 

[johannordgren]

Since I can't figure out how to remove a thread, I'll just tell you that I solved the problem..
I made 3 separete rules with different condition and applied all 3 to the same column.