Your conditions are ambiguous: the second condition probably should read:
Less than -5 to -10% OR Greater than 5 to 10%. The third probably Less
than -10 OR greater than 10%.

Please clarify.

Joerg

"Killashandrah" wrote in message
...
Hi,
I'm trying to format variance reporting so that a -5 to 5% range is green,
-5 to 10% AND 5 to 10% are amber, -11% and lesser AND 11% and greater are
red.

If anyone can help, I'd REALLY appreciate it!

Cheers :-)