+ Reply to Thread
Results 1 to 2 of 2

Create conditional formatting to help with payment dates

  1. #1
    Registered User
    Join Date
    10-08-2021
    Location
    Illinois, United States
    MS-Off Ver
    2102
    Posts
    1

    Create conditional formatting to help with payment dates

    Hey,

    I'm currently trying to create a conditional formatting formula which highlights my cells based on the dates I'm referencing from another cell with a date from last month. I.e. I want my payment date column to fill with whatever color if todays date is greater than the date from a month ago (today being Oct 8th, I want the cell to fill if the referencing cell has September 1st-7th).

    I have some knowledge but everything I've tried with the day, date, today & month formulas have failed. Any help would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Create conditional formatting to help with payment dates

    See the yellow banner at top of the page on how to attach your sample file.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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: 5
    Last Post: 12-03-2020, 01:45 PM
  2. Conditional formatting using dates and using dates without years
    By dcef79 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2014, 05:35 AM
  3. Replies: 11
    Last Post: 05-04-2014, 08:28 PM
  4. Conditional Formatting with approaching due dates and completed dates
    By rogernation in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2013, 04:12 PM
  5. Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  6. [SOLVED] Conditional Formatting of: dates within 1 month and dates before today.
    By Luke Smith in forum Excel General
    Replies: 5
    Last Post: 06-18-2013, 07:29 AM
  7. [SOLVED] How do I create conditional formatting to track due dates
    By Soraiya in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2005, 11:05 AM

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