Microsoft Office Forums MS project - appointment tracking with conditional format

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2019, 01:56 AM
cyan2 cyan2 is offline MS project - appointment tracking with conditional format Windows 10 MS project - appointment tracking with conditional format Office 2019
Novice
MS project - appointment tracking with conditional format
 
Join Date: Mar 2019
Posts: 1
cyan2 is on a distinguished road
Default MS project - appointment tracking with conditional format


Hello Everybody,


im trying to track appointments in MS Project 365.
Is it possible, to highlight a process via colour or symbol (e.g. red cross, with an additional column) if 2 conditions are given:


1. The process is not completed (<100% work completed, or maybe traffic light monitroing red)


2. 1 week before end date of process


The Point behind this, is to see (visual highlight), which processes are NOT completed, with a due date in 1 week (compared to current date), to have enough time to contact the person in charge of the process


Im asking if it is possible to solve this problem with conditional format in MS Project istelf, or if i have to transfer the date into Excel and analyse the processes there (with the use of VBA).


And if it is possible, how would the formel for the conditional format look like?


Thanks so far!


best wishes,
cyan
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS project - appointment tracking with conditional format Conditional format for times LeClef Excel 2 07-14-2018 11:07 AM
Conditional Formatting showing Tracking Status brucesw Outlook 0 12-01-2015 03:21 AM
How does this Conditional Format work? Gary Drumm Excel 7 04-16-2014 12:01 PM
MS project - appointment tracking with conditional format Project as a Staff-tracking Tool Kerry Project 1 03-01-2012 02:46 PM
Tracking resources in project new_to_project Project 3 07-06-2011 03:50 AM


All times are GMT -7. The time now is 02:51 AM.


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