Results 1 to 2 of 2

Thread: Conditional Formatting based on dynamic Date

  1. #1

    Question Conditional Formatting based on dynamic Date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an Excel file with conditional formatting (screenshot attached), if the condition is true, the entire row shall be highlighted (to Green) and have a top/bottom border.

    What I really need is for the condition to format based on the following criteria:


    -Highlight (Green) w/borders if the day for the previous month is greater than the 14th.
    Note1: ‘Previous month’ is the month before the Excel file was created.
    Note2: The date is in the format: Date [3/14/01]

    I need to evaluate only on the days (15th thru End-of-Month) based on the previous month from whenever the file was created.

    For instance:
    If the file was created on March, I need the Condition based the previous month (February) for the 15th thru End-of-Month.
    If the file was created on April, I need the Condition based the previous month (March) for the 15th thru End-of-Month.
    If the file was created on May, I need the Condition based the previous month (April) for the 15th thru End-of-Month.
    ...and so on.

    I've also attached an Excel sample of what I'm trying to do.

    Click image for larger version. 

Name:	Conditional_Formatting_based_on_Dynamic_Date.png 
Views:	13 
Size:	42.1 KB 
ID:	2648

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Please do not crosspost without links.

    READ: http://www.excelguru.ca/content.php?184


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •