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
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 - Senior Forums

All times are GMT -7. The time now is 12:56 AM.


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