Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2020, 07:22 AM
JohnnyG JohnnyG is offline Conditional Formatting Based on Progress Windows 10 Conditional Formatting Based on Progress Office 2019
Novice
Conditional Formatting Based on Progress
 
Join Date: Oct 2020
Posts: 3
JohnnyG is on a distinguished road
Default Conditional Formatting Based on Progress

I would like to set conditional formatting for tasks that indicates if the task is on track based on baseline start, baseline end, and the percentage complete.



Example:
If there is 100 days between baseline start and baseline finish and the project is on day 50 showing 50% complete, the indicator column would show Yellow for on track.

If we are on day 50 and we have 55% complete then indicator would be green to indicate we are ahead of the expected pace.

etc etc.

Has anyone wrote a formula like this before? I currently have the indicators set up but am not sure how this formula should look. Thank you in advance for any help that you may provide
Reply With Quote
  #2  
Old 05-13-2021, 03:19 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Conditional Formatting Based on Progress Windows 10 Conditional Formatting Based on Progress Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 35
ProjectPlanner is on a distinguished road
Default

This YouTube video might help you or anyone looking for a traffic light progress system.

Microsoft Project Progress Status Traffic Light - YouTube
Reply With Quote
  #3  
Old 05-15-2021, 12:58 PM
miless2111s miless2111s is offline Conditional Formatting Based on Progress Windows 7 32bit Conditional Formatting Based on Progress Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 31
miless2111s is on a distinguished road
Default

Have you had a look at the status column?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting based on date teza2k06 Excel 2 11-27-2018 09:55 AM
Conditional formatting to color cells based on number kallard Excel 4 12-26-2016 11:10 AM
Conditional Formatting Based on Progress Conditional Formatting based on dynamic Date Modifier1000 Excel 2 09-12-2014 08:53 AM
Conditional Formatting based on Value of Another Cell SteveBump Excel 3 03-07-2014 09:16 AM
Conditional Formatting Based on Progress Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 PM.


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