Conditionally format on result ranges
 

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 :-)

Conditionally format on result ranges
 

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 :-)

Conditionally format on result ranges
 

Agree with Joerg that your posted criteria is quite ambiguous

Assuming that your CF criteria is:
= -5% and <= 5% range is green,
5% and <= 10% range is amber,
< -5% or 10% range is red
(note that the above criteria is continuous numerically with no gaps)

then to apply the CF ...

Select the range, eg select A1:A10 (with A1 active),
apply the CF using "Formula is" as follows:

Cond1:=AND(A1=-5%,A1<=5%,A1<"")
Format: Green fill

Cond2: =AND(A15%,A1<=10%)
Format: Amber fill

Cond3: =OR(A1<-5%,A110%)
Format: Red fill
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Killashandrah" wrote:
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 :-)