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

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.