+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting if date is before today

  1. #1
    Registered User
    Join Date
    06-20-2006
    Location
    Detroit area, Michigan
    MS-Off Ver
    Microsoft Office 365 v16
    Posts
    68

    Conditional formatting if date is before today

    I would appreciate any assistance in achieving the following:
    I have a range of cells, H2..H1000, that are date values.
    I need to change the formatting to display the text in red if the date value is less than today()
    I've been fooling with it for days and cannot figure out how to get it to work.

    Appreciate any advice...

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Conditional formatting if date is before today

    Select the range

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =AND(H2 > 0,H2 < TODAY())

    Format as required
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Replies: 1
    Last Post: 06-09-2016, 11:38 AM
  2. [SOLVED] Conditional Formatting Based on Today's Date
    By EdWoods in forum Excel General
    Replies: 5
    Last Post: 05-10-2016, 06:19 AM
  3. Replies: 13
    Last Post: 12-13-2015, 03:09 AM
  4. Replies: 5
    Last Post: 04-07-2014, 06:02 AM
  5. Replies: 4
    Last Post: 02-13-2013, 01:18 PM
  6. Replies: 1
    Last Post: 01-24-2013, 04:52 PM
  7. Conditional formatting based on date - not today's!
    By HarveyDickinson in forum Excel General
    Replies: 1
    Last Post: 09-11-2009, 05:46 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