Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2021, 12:15 AM
Sohan Sohan is offline Color coding "% Work Completed" column based on completion  value Windows 10 Color coding "% Work Completed" column based on completion  value Office 2019
Novice
Color coding "% Work Completed" column based on completion  value
 
Join Date: Aug 2021
Posts: 1
Sohan is on a distinguished road
Default Color coding "% Work Completed" column based on completion value

Hi All,


Noobie here..

I want to be able to color code the cells in "% Work Completed" column based on their value.

For example when:
%= 100 Background is Green;
%= >0<40, Cell Background is Yellow;
% = >39<100, Cell Background is Amber;
% = 0 Cell Background is Blue.

Can anyone help with the details on how I could make this happen?

Thanks.
Attached Images
File Type: png Capture.PNG (17.2 KB, 5 views)
Reply With Quote
  #2  
Old 08-18-2021, 12:12 PM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Color coding &quot;% Work Completed&quot; column based on completion  value Windows 10 Color coding &quot;% Work Completed&quot; column based on completion  value Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 52
ProjectPlanner is on a distinguished road
Default

Not sure the conditional formatting you are after is possible. You can use "Marked" text style to highlight one value but not 4 values that you are after.

How about using graphical indicators to achieve the same thing with a custom text field? This video might help you. Microsoft Project Progress Status Traffic Light - YouTube
Reply With Quote
Reply

Tags
conditional formatting, project 2016, vba change color

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional function to operate a formula based on "Yes" or "No" Condition Des ONeill Excel 1 07-03-2021 12:17 AM
Color coding &quot;% Work Completed&quot; column based on completion  value Formula to format "I" column based on if "F" column row is not blank ravl13 Excel 3 08-22-2017 12:26 PM
Color coding &quot;% Work Completed&quot; column based on completion  value how can I modify this macro to work on another column besides "A" zhead Excel Programming 5 10-06-2015 05:04 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N mikey386 Excel 2 12-11-2014 01:14 PM
Color coding &quot;% Work Completed&quot; column based on completion  value "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 PM.


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