Closed Thread
Results 1 to 9 of 9

Conditional Format - Dates greater than 18 months and 24 months

Hybrid View

  1. #1
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Conditional Format - Dates greater than 18 months and 24 months

    So if the date in column E is more than 24 before todays date, colour cell red, is that correct?

    And if the date in column E is more than 18 months before todays date, but less than 24 months before todays date, then colour the cell yellow? Is this the right logic?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  2. #2
    Registered User
    Join Date
    12-06-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Conditional Format - Dates greater than 18 months and 24 months

    Yes that is correct.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. conditional format if date in field is within the next 6 months
    By Jason_C in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2017, 02:17 AM
  2. Number of months (elapsed months) between two dates
    By Timbite in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2012, 11:37 AM
  3. Replies: 0
    Last Post: 04-13-2012, 03:10 AM
  4. Conditional Format for Odd-Even Months
    By Excellant in forum Excel General
    Replies: 6
    Last Post: 02-26-2010, 05:35 PM
  5. [SOLVED] Adding months to dates should account for 28-30-31 day months
    By Graham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2006, 08:10 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