Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 13 views)
Reply With Quote
 

Tags
conditional formatting, project 2016, vba change color



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 05:56 PM.


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