Ask Your Question

Display percent value as progress bar, in cell? [closed]

asked 2013-01-21 18:47:35 +0100

djaquay gravatar image

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).

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Alex Kemp
close date 2015-10-20 20:34:51.641585

1 Answer

Sort by » oldest newest most voted

answered 2013-01-21 19:10:20 +0100

horst gravatar image

Have you looked at Conditional Formating? Have a look at the following Question (

edit flag offensive delete link more

Question Tools


Asked: 2013-01-21 18:47:35 +0100

Seen: 5,572 times

Last updated: Jan 21 '13