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.
Bookmarks