Progress Bar on Mac 2011

[FalconMechanic]

I want to create a progress bar on Excel for Mac 2011.

I used Conditional Formatting > Data Set. I followed this method: www.tech-recipes.com/rx/35064/excel-2013-create-progress-bars/

This normally works for Excel on Windows. On Mac Excel, it fills half the bar and never changes according to progress. Do you know how this is fixed?

 

[mikerickson]

It works for me on Excel 2011

 

[FalconMechanic]

Can you send a link or paste the formula you used? (I am new to the forum; Is there a way to upload an excel file?)

 

[mikerickson]

There's not a formula involved. Your link shows how to set conditional formatting to make a bar in a cell, the length of which depends on the value in the cell. I used Numbers as the Type on the dialog box.

 

[FalconMechanic]

There's not a formula involved. Your link shows how to set conditional formatting to make a bar in a cell, the length of which depends on the value in the cell. I used Numbers as the Type on the dialog box.

</P>
I see where the problem lies. Where you have used Numbers Type, I was using Percentage Type. My Progress Bar was to show how close I was to task completion. However, when the Type is changed to Percentage (or even when the Cell Format is changed to Percentage), the progress does not respond.
</P>
Now that I understand where the problem lies, I need to find the solution.

 

[mikerickson]

Change it to number.