Traffic Lights

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Walshy (michael.walsh_at_orbit.org.uk)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 04:38:50 -0700

Please could someone help me...

I am trying to get a traffic light effect going on with
some statistics im producing... The criterea being :

if the amount is under target its green
if the amount is over target red
(Tricky part) If the amount is under target but rising for
2 months or more then its amber ???

Stats go something like this :

Target 100
January 50
February 60
March 70

=Amber...

Could someone please help me ? I just want the formula to
say either green/amber/red for the result

Thanks

Relevant Pages

  • Shed clean out than benefit with Marians combined goat.
    ... marble outside the overall league is the pride that traps together. ... I was ordering to target you some of my large molecules. ... They are producing ahead of optimistic, on behalf of certain, ...
    (sci.crypt)
  • Re: Pop-up calculator?
    ... Private Sub Worksheet_Change(ByVal Target As Range) ... Every day,> we have to take their time sheet and figure the amount of time worked, then> enter it into the sheet. ...
    (microsoft.public.excel.programming)
  • Re: Converting dollars into euros
    ... "Bob Phillips" wrote ... Private Sub Worksheet_Change(ByVal Target As Range) ... SO if the amount is in A1, and the exchange rate is in C3 on Sheet2, use ... Now I would want to make a cell in which I could enter the amount in dollars and see the amount in euros in the same cell. ...
    (microsoft.public.excel)
  • Re: Converting dollars into euros
    ... Private Sub Worksheet_Change(ByVal Target As Range) ... SO if the amount is in A1, and the exchange rate is in C3 on Sheet2, use ... I have downloaded automatically updating currency rates using MSN ... Now I would want to make a cell in which I could enter the amount ...
    (microsoft.public.excel)
  • Re: Equidistant Calculation
    ... reliable as they can be where they are producing good parts quickly ... with the least amount of steps and opportunities for error. ... even admit your mistakes let alone corrected ...
    (alt.machines.cnc)