+ Reply to Thread
Results 1 to 3 of 3

Employee Review Tracker

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Employee Review Tracker

    Hello Everyone,

    I am trying to figure out some formatting for my review tracker. See below for details....

    Column B = Hire Date
    Column C = 45 Day Review Date
    Column D = Date the Review took place

    I would like column C to be 45 days past the hire date, column B, and to highlight if it is later than the current date. With that, I want it to NOT be highlighted if there is date in column D.

    Hope this isn't confusing.

    Thanks !Review Tracker.xlsx

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Employee Review Tracker

    Maybe like this.

    See the green cells in the attached file.

    You could filter on column E to "To late".
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Employee Review Tracker

    Maybe something like this might work. There is a a warning via Conditional Formatting that a review is coming within 7 days and on the date due the date turns red.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Autofill or link data from one tab to other tabs in Excel 2010
    By AverageJExcel in forum Excel General
    Replies: 1
    Last Post: 10-16-2014, 07:03 PM
  2. Employee Trainging Tracker
    By lalynnsmi85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2013, 11:44 PM
  3. [SOLVED] Employee attendance tracker
    By akash kothari in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-11-2013, 08:08 AM
  4. [SOLVED] Employee attendance tracker
    By sanjeevi888 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-19-2012, 12:54 PM
  5. [SOLVED] Help with an employee time tracker.
    By jbunk in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 09:03 PM

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