Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2023, 11:41 AM
kbrumbelow kbrumbelow is offline Procurement Log Tracking Help! Windows 10 Procurement Log Tracking Help! Office 2019
Novice
Procurement Log Tracking Help!
 
Join Date: Jan 2023
Posts: 1
kbrumbelow is on a distinguished road
Default Procurement Log Tracking Help!

Hello,

My brain is fried. Attached is the current document I am working on.

I would like the document to do the following:
-Turn red if the required date is past due
-Turn orange if the required date is in the next 5 days

-Create a summary page of the following, from each sheet:
Material Submittals Due within 5 Days
Material Approvals Past Due
Delivery to Site within 5 Days
Delivery to Sire Past Due



Thank so so so much in advance!
Attached Files
File Type: xlsx Procurement Log.xlsx (28.2 KB, 3 views)
Reply With Quote
  #2  
Old 01-07-2023, 02:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Procurement Log Tracking Help! Windows 10 Procurement Log Tracking Help! Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
lots of flashy colors, merged cells...Nothing tried. I'll pass
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
change tracking eNGiNe Visio 0 01-16-2015 05:26 AM
Procurement Log Tracking Help! Tracking Amounts teza2k06 Excel 1 04-13-2014 09:28 PM
Tracking Mail wahyu Outlook 1 09-09-2013 07:28 AM
Vehicle tracking MOT due babypink Outlook 0 07-01-2012 06:33 AM
Where is the 'tracking tab' within the Sent file? prdtxsgal Outlook 3 01-27-2006 10:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft