I have a terrible Excel spread sheet that holds just some simple date data. It is a list of all the drivers that I work with
drivers License. expiration dates and other documents that expire. I am the only one in my office that has any knowledge of
how to get Excel to do anything and I have only basic know how of using simple formulas, simple logical operators, and simple
conditional formatting. I opened my mouth and said I could get this mess of a spread sheet to basically keep its self up to
date, because they are doing everything manually. Then I started working on it and well its beyond what I can do I think.
I need the sheet to subtract Todayís date [ =TODAY() ] from Exp. Date and at 90 days till Expiration turn the
background of the cell yellow and display "90 Days". Then at 60 days same thing, again at 30 but change background
to red display " 30 Days!" in yellow or black font, and stay with these colors but change message at "2
Weeks!", "1 Week!", "5 Days!", "3 Days!", "2 Days!", "1 Day!",
I thought this could be done with just nesting multiple If Statements with some
conditional formatting. So I started out just trying to get (1) If Function to work with conditional formatting changing the
background to yellow. I then figured it would just be a matter of nesting then. I can write a If Function that subtracts the
dates and returns "90 Days" for the true part. I can write a conditional statement that changes the background to
Yellow but I can't seem to put the two together. Thatís when I saw that this is probably going to require some programming
and that is beyond me.
I am not sure how to approach this but this appears to me that it is a lot of programming
and maybe I need to contact an individual programmer privately. If that is the case then all I need is someone to please
point me in direction of how to go about doing that. I realize there is plenty of available material offered here that I can
teach myself how to do this type of thing but right now I am just a truck driver without much time. I need this type of Excel
Spreadsheet pretty much now. Also I do not claim at work that anything I learn here is my work, I tell people here if can't
do it I know where to go ask. Getting free help with simple stuff is one thing but complicated programming that requires
people who have taken years to learn something is quite another.
If you want to know the best way to drive a truck
from Florida to BC I will be happy to tell you, but if you want me to do it I will probably charge you 1.65 a mile plus the
cost of fuel and insurance. I am currently working in Iraq with a bunch of people who really have no idea how to keep and use
the spread sheets they are working with so I try to help out. If I wrote too much here I apologize, just thought it might
help to understand where I am coming from.