+ Reply to Thread
Results 1 to 3 of 3

Applying conditional format to dates based on current year and 6 month intervals

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    England
    MS-Off Ver
    2013
    Posts
    3

    Applying conditional format to dates based on current year and 6 month intervals

    Good afternoon all,

    So I have finally relented and joined a forum as I cannot for the life of me work out how to achieve what I am after, and I just hope someone else here can help me!

    So I have a sheet within my workbook that lists the serial numbers of fire extinguishers and their given location. It also shows an expiration date column.

    The various fire extinguishers have expiration dates currently up until the year 2023.

    We have to replace / re-validate the fire extinguishers when they come towards the end of their life....However we only have two windows to replace them, one in June and one in December.

    The dates currently are in the format mm/yyyy (E.g 03/2021)

    I am trying to apply a conditional format that will check the year (if current year) and within the set exchanging times. So if dates occur within the first exchange period they go red, if they fall in the second exchange period they go yellow.

    At which point if possible the exchange period would need to alternate?

    Please tell me if I am not making sense!
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: Applying conditional format to dates based on current year and 6 month intervals

    Use these formula in the conditional window:

    Please Login or Register  to view this content.
    Select according color to the right formula.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: Applying conditional format to dates based on current year and 6 month intervals

    I forgot to attach the workbook with the conditionnal formulas.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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