Results 1 to 7 of 7

Highlighting Custom Date Function

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2019
    Location
    Richland, MS
    MS-Off Ver
    2019
    Posts
    4

    Exclamation Highlighting Custom Date Function

    I am creating a spreadsheet for work and am attempting to add a highlighting rule that applies a yellow highlight to a cell in a specific column (F) IF the date is more than 60 days ago from the current date (updating daily).
    I have created a new rule with

    =F1<(TODAY()-60)

    It is not telling me that the formula is wrong. It creates the rule no problem, but does not change any of the cells it should be changing.

    Can anyone help me see what I'm doing wrong???

    Thank you in advance.
    Last edited by samiam2013; 08-20-2019 at 04:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Highlighting Closest Date
    By werevollf in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2019, 05:17 AM
  2. macro for highlighting which will consider date
    By glaedr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2016, 07:57 PM
  3. [SOLVED] Highlighting Date
    By SeeMun in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-22-2016, 11:45 AM
  4. DAY() function is not working for custom date format
    By milindbharambe in forum Excel General
    Replies: 17
    Last Post: 04-24-2014, 07:19 AM
  5. Highlighting row based on the date
    By mamuka12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 02:22 PM
  6. Highlighting a Row with the current Date
    By Hickup in forum Excel General
    Replies: 14
    Last Post: 03-07-2012, 11:17 AM
  7. Excel 2007 : Highlighting a Row with a Certain Date
    By Ormond2009 in forum Excel General
    Replies: 6
    Last Post: 03-29-2010, 03:02 PM

Tags for this Thread

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