Results 1 to 2 of 2

Conditional format cells based upon matching cells & date range from today?

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2022
    Location
    Kettering, OH
    MS-Off Ver
    365
    Posts
    11

    Conditional format cells based upon matching cells & date range from today?

    Hello,

    Please see attached and see sheets Cycle_Count_Sample & Stock Movement Cycle Count.
    I have a list of all inventory on the Cycle_Count_Sample sheet (most items removed).
    I have a list of inventory that's been cycle counted on the Stock Movement Cycle Count sheet (most cycle counts removed).
    I'm wanting to have conditional formatting highlight all items that have been cycle counted over the past 3 months (91 days), based upon the dates in the Stock Movement Cycle Count sheet. Please see how the highlighting should appear. As you can see, rows 2-11 aren't highlighted due to the item #s not appearing on the Stock Movement Cycle Count sheet, and row 16 isn't highlighted due to the date being greater than 91 days older than today (3/18/22).
    Is this function possible? If so, how?

    Thank you.
    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 Format Needed to highlight based on matching text in certain cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2020, 09:17 PM
  2. [SOLVED] How to format range of cells if J4 date is today?
    By Mr.Castle in forum Excel General
    Replies: 5
    Last Post: 09-01-2019, 02:50 AM
  3. Replies: 4
    Last Post: 02-06-2017, 10:20 PM
  4. Replies: 1
    Last Post: 09-30-2012, 03:01 PM
  5. Replies: 3
    Last Post: 09-13-2012, 03:25 AM
  6. Conditional Formating of cells based on today's date, and another date
    By dviolante10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2012, 02:32 PM
  7. Replies: 3
    Last Post: 12-11-2007, 01:36 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