Prev: Top 5 recurring text values with count
Next: CONVERT EXCEL DOCUMENT TO PDF FORMAT
From: Ruby Pro Ruby on 5 May 2010 18:10
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.
From: Bob Phillips on 5 May 2010 19:05
See http://www.xldynamic.com/source/xld.CF.html#lights


--

HTH

Bob

"Ruby Pro" <Ruby Pro(a)discussions.microsoft.com> wrote in message
news:2F5F9553-D2ED-483D-8626-F9880B09D079(a)microsoft.com...
> 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.


From: Max on 5 May 2010 19:13
This set of CF formulae should work fine for you
Amounts monitored are assumed in A2 down

Green
=AND(ISNUMBER($A2),$A2>0)
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.
From: Herbert Seidenberg on 5 May 2010 21:47
Excel 2007 PivotTable
Conditional Formatting
Icon Set = 3 Traffic Lights
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_05_10a.xlsx
Pdf preview:
http://www.mediafire.com/file/gjyi2ndzygk/05_05_10a.pdf
From: Ruby Pro on 6 May 2010 12:34
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),$A2>0)
> 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.
 |  Next  |  Last
Pages: 1 2
Prev: Top 5 recurring text values with count
Next: CONVERT EXCEL DOCUMENT TO PDF FORMAT