Conditional Formatting using Traffic Lights

Would like to set up conditional formatting where I can show a green light
for amounts above 0%, yellow light for below 0% but greater than -5%, and red
for anything below negative 5%. Appreciate your help.

See http://www.xldynamic.com/source/xld.CF.html#lights


--

HTH

Bob

"Ruby Pro" Ruby wrote in message
...
Would like to set up conditional formatting where I can show a green light
for amounts above 0%, yellow light for below 0% but greater than -5%, and
red
for anything below negative 5%. Appreciate your help.

This set of CF formulae should work fine for you
Amounts monitored are assumed in A2 down

Green
=AND(ISNUMBER($A2),$A20)
Yellow
=AND($A2"",$A2=0,$A2-5%)
Red
=$A2-5%

Success? hit the YES below
--
Max
Singapore
---
"Ruby Pro" wrote:
Would like to set up conditional formatting where I can show a green light
for amounts above 0%, yellow light for below 0% but greater than -5%, and red
for anything below negative 5%. Appreciate your help.

Excel 2007 PivotTable
Conditional Formatting
Icon Set = 3 Traffic Lights
http://c0718892.cdn.cloudfiles.racks...05_05_10a.xlsx
Pdf preview:
http://www.mediafire.com/file/gjyi2ndzygk/05_05_10a.pdf

I don't follow. Can you help me out with how I would write this formula?

"Max" wrote:

This set of CF formulae should work fine for you
Amounts monitored are assumed in A2 down

Green
=AND(ISNUMBER($A2),$A20)
Yellow
=AND($A2"",$A2=0,$A2-5%)
Red
=$A2-5%

Success? hit the YES below
--
Max
Singapore
---
"Ruby Pro" wrote:
Would like to set up conditional formatting where I can show a green light
for amounts above 0%, yellow light for below 0% but greater than -5%, and red
for anything below negative 5%. Appreciate your help.

This works! Thanks for the pdf preview.

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Conditional Formatting
Icon Set = 3 Traffic Lights
http://c0718892.cdn.cloudfiles.racks...05_05_10a.xlsx
Pdf preview:
http://www.mediafire.com/file/gjyi2ndzygk/05_05_10a.pdf
.

The 3 formulas are all given clearly in my response? You simply apply it in
the CF using "Formula Is" as conditions 1, 2, 3 (it can be placed in any
order as the checks are mutually exclusive, no overlaps, no gaps). The
colour indicated is what you would then choose as the trigger format. This
formulas route is the nuts and bolts way of getting it done, and it'll pay
you dividends to grasp it.

"Ruby Pro" wrote in message
...
I don't follow. Can you help me out with how I would write this formula?

"Max" wrote:

This set of CF formulae should work fine for you
Amounts monitored are assumed in A2 down

Green
=AND(ISNUMBER($A2),$A20)
Yellow
=AND($A2"",$A2=0,$A2-5%)
Red
=$A2-5%

Success? hit the YES below
--
Max
Singapore
---
"Ruby Pro" wrote:
Would like to set up conditional formatting where I can show a green
light
for amounts above 0%, yellow light for below 0% but greater than -5%,
and red
for anything below negative 5%. Appreciate your help.