As you can see, the task bar currently highlights gray dependent on the start and end dates of the task using the formula
In non-cell specific terms:
I want to keep that function, but I want to add an aspect that will change that bar color dependent on if the progress percentage is 100%. (Essentially a visual way to show that task is complete vs. just scheduled.
Right now, all I can get is for the cells to change color up to those gray bars or after those gray bars, but I can't get the color to change in the gray bar itself. Any ideas on how I need to change my function to add this capability?