Results 1 to 5 of 5

Conditional format to highlight older dates from today in colours

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    307

    Conditional format to highlight older dates from today in colours

    I am trying to format the date cells to see what needs updating, so depending how old it is the fill colour will change from blue recent through to red very old.

    I have tried to put a conditional format in that i thought would do it, but it isn't working.

    If anyone can have a look and advise please, i would appreciate it.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting - Dates older than Today
    By Wheelie686 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-06-2018, 08:34 AM
  2. [SOLVED] Conditional Formatting to Highlight a Range when Today is between Two Dates DD/MM
    By AliGW in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-04-2015, 11:10 AM
  3. [SOLVED] Conditional format for dates older than a specified date
    By goneoffbeans in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2015, 04:54 AM
  4. Replies: 3
    Last Post: 11-20-2013, 08:42 AM
  5. Conditional format between dates based on today()
    By StevieNix in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-27-2012, 06:06 PM
  6. Replies: 4
    Last Post: 03-12-2012, 03:44 AM
  7. Conditional Formatting Today and Older
    By ConsbruckR in forum Excel General
    Replies: 7
    Last Post: 03-18-2009, 04:31 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