there has been a lot of post on this topic, Please search. I have put several
answers as have several others.

"Jim Brass" wrote:

Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim