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