Is there a way to take a cell that has a percent value, (e.g. 0 <= x <= 1), and display it as a progress bar? I’d like to track a long list of (several hundred) items, each of which will have a percent-done value, and as they’ll be nested, I’d like to have formulas calculate the percent-done value for the parents, based on what I’ve entered for the “child” rows. But I’d really like a visual display of these values (e.g. a progress bar that’s the width of the column).
Have you looked at Conditional Formating? Have a look at the following Question (Color scales and data bars)