+ Reply to Thread
Results 1 to 2 of 2

One trafficlight index is depending on 2 cells

  1. #1
    Registered User
    Join Date
    09-28-2015
    Location
    Hamburg, Germany
    MS-Off Ver
    2010
    Posts
    10

    Lightbulb One trafficlight index is depending on 2 cells

    Hey Everyone,

    i really hope i can find some help here

    So im creating this Orderingsystem for a friend of mine, where i implemented a KPI Index which changes it colour depending on how many days, since the order has been placed, passed by.
    So far so good.

    I used this formular: =IF(J4="";"";TODAY()-J4)

    KPI.png

    So my question is:
    When i enter another date in "Ware bestellt" or L4, i want the KPI to turn green or maybe any other color to show that this product has been ordered.
    Is it possible to that the KPI can get the data from two different cells? Maybe through a interlaced IF-Formula?

    Thank you so much in advance !!!
    Mona

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    606

    Re: One trafficlight index is depending on 2 cells

    Maybe:-

    =IF(J4="","",IF(L4="",TODAY()-J4,1))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula checks multiple cells for words and outputs answer depending on cells
    By keez1993 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2015, 09:18 AM
  2. Replies: 2
    Last Post: 05-14-2015, 03:19 PM
  3. Index match with conditions depending on content of other cells
    By dudeonthebayou in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2015, 02:11 PM
  4. [SOLVED] Priority Rank depending on blank cells w/ bypassing cells with content
    By eaflynn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2015, 01:30 AM
  5. Insert formula depending on cells depending of variables
    By elmexicano87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2014, 01:22 PM
  6. Replies: 4
    Last Post: 01-10-2014, 05:09 PM
  7. Replies: 2
    Last Post: 04-05-2012, 08:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1