Don't forget the you can have quite a complex formula (with and's
& OR's and < & >) in the conditional formatting box. I use this to
format font colors based  on value and have a formula so complex that
it is not all visable in the text box [the edit capability is really
awkward like this too). I actually exceeded the length for one and
had to use all three conditional boxes to get what I wanted. I have
something between 20 and 30 value limit tests.