+ Reply to Thread
Results 1 to 5 of 5

Change colour of date to red when date has passed

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    17

    Change colour of date to red when date has passed

    Hello

    I am trying to change the colour of a cell when the date in that cell has passed.

    I have tried a conditional formatting rule as uploaded in the word document attached but it doesn't work.

    Can you help please?
    Attached Files Attached Files
    Last edited by WSRSJT; 08-05-2020 at 10:21 AM. Reason: upload example of formula used

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Change colour of date to red when date has passed

    Conditional formatting rule like =A2 < Today() for dates in the past comparing with today's date.
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    10-29-2014
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Change colour of date to red when date has passed

    Thank you, would you mind looking at the uploaded example of the conditional formatting that I tried - it doesn't work

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,542

    Re: Change colour of date to red when date has passed

    Please utilize the instructions in the banner at the top of the page to upload an .xlsx file.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    10-29-2014
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Change colour of date to red when date has passed

    Thank you for all your help, the =>TODAY() conditional formatting has worked

+ 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. Change a cell value after a specified date has passed.
    By richard11153 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2020, 03:54 PM
  2. [SOLVED] Change Date based on due date passed
    By Murdo132 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2019, 08:52 AM
  3. Replies: 6
    Last Post: 04-24-2015, 03:16 AM
  4. Replies: 5
    Last Post: 02-03-2015, 09:08 PM
  5. Replies: 4
    Last Post: 11-26-2014, 09:22 PM
  6. Replies: 6
    Last Post: 08-23-2012, 12:14 PM
  7. Replies: 1
    Last Post: 03-22-2010, 04:09 PM

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