Results 1 to 8 of 8

Using conditional formatting to highlight dates with formula (certain criteria)

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2020
    Location
    South Africa
    MS-Off Ver
    Microsoft Office Home & Business 2016
    Posts
    9

    Question Using conditional formatting to highlight dates with formula (certain criteria)

    Good Day,

    I need help with a formula that will highlight a date meeting certain criteria.

    Spreadsheet example attached.
    In column B we will input a date (let's use 04/11/2020 as an example)
    I need the cell to highlight when the date reaches 7 days or less from 30 days from that date.

    Not sure how to explain it, but using the above example, 30 days from 04/11/2020 will be 04/12/2020, and I need the cell to highlight in red when today's date is 7 days or less from 04/12/2020

    The dates will not all be the same, but I need the formula to calculate the formula without having to input another column that shows the 30 days date.

    Please let me know if anyone can help, an please let me know if this is too confusing. I will try to explain it better

    Thanks Gisela
    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. Conditional Formatting to Highlight Dates in a Column
    By tatertot7 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2019, 03:36 PM
  2. Conditional Formatting to highlight consecutive dates?
    By LisaSchon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2018, 04:32 AM
  3. [SOLVED] Conditional Formatting formula to highlight a column if multiple criteria are not met.
    By KMJ256388 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2018, 09:36 AM
  4. Need a 'conditional formatting' formula to highlight cells between dates/text
    By BigSean762 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2014, 02:33 PM
  5. [SOLVED] Conditional formatting to highlight old dates?
    By mhaness in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2014, 11:57 AM
  6. Replies: 5
    Last Post: 09-24-2012, 05:14 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