+ Reply to Thread
Results 1 to 13 of 13

Conditional formatting- Anniversary of a date is due

Hybrid View

robrobet Conditional formatting-... 10-25-2014, 04:50 PM
mrice Re: Conditional formatting-... 10-25-2014, 05:05 PM
robrobet Re: Conditional formatting-... 10-25-2014, 05:15 PM
alansidman Re: Conditional formatting-... 10-25-2014, 05:18 PM
robrobet Re: Conditional formatting-... 10-25-2014, 05:30 PM
mrice Re: Conditional formatting-... 10-25-2014, 05:30 PM
alansidman Re: Conditional formatting-... 10-25-2014, 06:44 PM
robrobet Re: Conditional formatting-... 10-25-2014, 07:22 PM
robrobet Re: Conditional formatting-... 10-25-2014, 07:25 PM
protonLeah Re: Conditional formatting-... 10-25-2014, 07:30 PM
robrobet Re: Conditional formatting-... 10-25-2014, 07:37 PM
mrice Re: Conditional formatting-... 10-26-2014, 01:59 PM
robrobet Re: Conditional formatting-... 10-26-2014, 03:39 PM
  1. #1
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Conditional formatting- Anniversary of a date is due

    Did you look at my examples?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  2. #2
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    165

    Re: Conditional formatting- Anniversary of a date is due

    Yes i saw, but did not work the way i want. if there is date for dec month that also turn to red. I do not how I do this. I am working on employee review file, I want cell to change yellow when they are close to their review and turn red when they pass the date. but I am not sure how to do if the employee start date is like if they start in dec 2009. so their review is not due and not close to due but they also turn to red.

  3. #3
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    165

    Re: Conditional formatting- Anniversary of a date is due

    is there any macro that look for those dates and do the magic

+ 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. Payroll Date/Anniversary Calculations?!?
    By InFeKtId in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-04-2014, 10:33 AM
  2. [SOLVED] Formula assistance needed to sum data based on anniversary date and month date
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 11:18 PM
  3. Employee Anniversary date - Conditional Formatting
    By shona3086 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-30-2012, 05:21 AM
  4. Anniversary Date Recognition Formula Help?
    By onflight1978 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2010, 02:00 PM
  5. Recurring anniversary date
    By mcarr5 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2009, 10:43 AM

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