Prev: Top 5 recurring text values with count
Next: CONVERT EXCEL DOCUMENT TO PDF FORMAT
From: Ruby Pro on 6 May 2010 12:35
This works! Thanks for the pdf preview.

"Herbert Seidenberg" wrote:

> 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: Max on 13 May 2010 19:22
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" <RubyPro(a)discussions.microsoft.com> wrote in message
news:98715B9B-2626-43D5-B436-191BFAF19DB2(a)microsoft.com...
> 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.

First  |  Prev  | 
Pages: 1 2
Prev: Top 5 recurring text values with count
Next: CONVERT EXCEL DOCUMENT TO PDF FORMAT