Conditional Formatting Help Needed to Show Status in a Project Management Sheet

[koneill828]

Hi All,

I am revamping a project management sheet for my department. I have attached the document below. I am trying to use conditional formatting to make the bars at the right (the orange/blue bars) to automatically update when the percentage under "% Complete" is updated. For example, if something is 100% complete, the bar corresponding with that line should be completely orange. If the project is 50% complete, the bar should be 50% orange and 50% blue. I had based the formula off of an example I found online, but it doesn't seem to be working so wondering if there is a different formula that I could use instead.

Right now, it is under conditional formatting > use a formula to determine which cells to format > and code is:

Please Login or Register  to view this content.

[JeteMc]

Try the following:
1. Modify the formula in G14 and down to read: =IF(OR(D14="",E14=""),"",NETWORKDAYS(D14,E14))
2. Apply the following custom formatting to cells G14 and down: 0 "day(s)"
3. Use the following formula as conditional formatting rule for orange: =AND($I14>5%, $D14<=K$10,$E14>=K$10,WORKDAY($D14,ROUNDDOWN($G14*$I14,0))>K$10)
Let us know if you have any questions.