Results 1 to 6 of 6

Conditional Formatting for five and ten year milestones

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2017
    Location
    Seattle, US
    MS-Off Ver
    Office 2016
    Posts
    2

    Conditional Formatting for five and ten year milestones

    Hi all,

    I am attempting to make a sheet that tracks our five and ten year awards plus a ten year longevity. Currently I have each employee's hire date in the H column, the five year award in the J column, a ten year award in the K column, and the ten year longevity. I know there are two columns that will trip at the same time but i want to check them off once the employee recieves the award. the other part of this is I would like the cells to turn yellow when they are within a year of the milestone and red if it is past the milestone (five or ten years from hire). Thank you for your help. Matt
    Last edited by MULegacy; 09-05-2017 at 10:22 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional formatting Highlight Past Year...?
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-10-2015, 12:03 PM
  2. Conditional Formatting Using Prior Year Data
    By JoseK70 in forum Excel General
    Replies: 2
    Last Post: 10-02-2013, 10:33 AM
  3. Conditional Formatting (Milestones)
    By RuggyRiot in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 11:32 AM
  4. Replies: 4
    Last Post: 06-23-2011, 11:45 AM
  5. Conditional Formatting, Date Greater Than 1 Year
    By jshpik1 in forum Excel General
    Replies: 10
    Last Post: 11-24-2010, 07:32 PM
  6. Conditional Formatting more than one year old
    By Stormdancing in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-29-2008, 04:33 AM
  7. Formula for Fiscal Year Conditional Formatting
    By eppersbl in forum Excel General
    Replies: 1
    Last Post: 07-18-2006, 03:45 PM

Tags for this Thread

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