I want a report template created so I can download a data set, drop it into the format and have some very specific date related conditional formatting occur. Specifically I want to track multiple upcoming dates and compare dates of expected and actual milestones. There are 25 columns of data and I want Icons as well as cell formatting that displays color to be added. I would like it to auto update so every week when I drop new data in it functions the same. (Meaning off todays date). Of the data columns there are 10 groups of 2 that need compared. An example is expected date of 1/1/17 and was completed on 1/2/17 should be a RED BORDER and Black Text. If it's 1/1/17 and that task is due today (or this week) it should show up as YELLOW FILL with Black text. If the activity was due yesterday or any date prior and the actual is still blank then the ACTUAL date cell should be BRIGHT RED FILL with no text. If the Actual and the Expected are a match or completed early it shows as GREEN Border and Black Text.
4 freelanceria on tarjonnut keskimäärin 129 $ tähän työhön
I complete your project in short time as soon as posible my concentration on no quilty compromise I have 4 year experience in data entry accounts work and Email and social media handling .