+ Reply to Thread
Results 1 to 2 of 2

Creating a "simple" gift card tracking system

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Ontario, Canada
    MS-Off Ver
    2013
    Posts
    1

    Question Creating a "simple" gift card tracking system

    Hello,

    I am a little beyond novice at using excel, I can balance a basic budget book, and that's about it.

    but I am trying to do something a little more advanced here.

    I want to track gift cards, I have a simple 4 section chart, and I want something like the if, than function usable in java programming.
    so my chart looks like this:



    l_______Gift Card Number_______l____Current location____l____Value____l______Expiry date______l______Status____l
    l____________001______________l______Drawer_________l____0.00_____l_____ 00/00/0000______l____DRAWER____l
    l____________002______________l__Customer Possession_l____50.00_____l_____ 04/10/2013______l____EXPIRED____l
    l____________003______________l__Customer Possession_l____50.00_____l_____ 04/10/2016______l____ACTIVE_____l
    I want to make it do the following:

    if the Status is drawer than value, and expiry should zero out, and Current location should show "drawer" and the line yellow as shown on card 1
    if Expiry date is past today than status should be expired, and line should be red (card 2)
    if the expiry date is before today, and the card is not in drawer then the line should be green (card 3)

    I have attached a sample file for reference

    Thanks Guys & Gals

    MattGift Card Tracker Sample.xlsx

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,747

    Re: Creating a "simple" gift card tracking system

    Try these formulas. In C2:C4
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In E2:E4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    .

    For the status conditional formatting (formatting by formula).
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Set two more CF

    formulas for the other two replacing "DRAWER" with appropriated status.

    File is attached.
    Attached Files Attached Files
    Last edited by FlameRetired; 01-20-2015 at 12:52 AM.

+ 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. Gift card inventory & invoicing
    By meesha26 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 09:21 AM
  2. Conjoint Market Simulator - $10 Amazon gift card
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 11:25 AM
  3. Macro to hide rows - Amazon gift card to whoever can help!
    By reubank in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-22-2013, 06:29 AM
  4. [SOLVED] Problem creating Line Chart from columns "date" and "money"
    By brosef in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-05-2012, 09:01 AM
  5. Merging a "physical count" to a "system on-hand"
    By raharms in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2010, 04:43 AM

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